| From: | <david(at)andl(dot)org> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Proper relational database? |
| Date: | 2016-04-24 02:33:28 |
| Message-ID: | 004b01d19dd1$b1a325c0$14e97140$@andl.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Absolutely not. SQL is a (nearly) full implementation of the relational algebra, plus other non-relational stuff. The only thing it really can't handle is a table with no columns! (I have to fake that)
a table with no columns would have no primary key... doesn't that violate one of the fundamental tenets of the relational model ?
john r pierce, recycling bits in santa cruz
The relational model requires a key, but the key can be empty (no attributes). Such a relation can itself be empty, or it can have a single tuple as its body. The maths requires it, and it works just fine.
Regards
David M Bennett FACS
_____
Andl - A New Database Language - andl.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Bennett | 2016-04-24 02:43:29 | Re: Proper relational database? |
| Previous Message | Venkata Balaji N | 2016-04-24 02:00:00 | Re: Is it possible to recover the schema from the raw files? |