| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | Michael Grant <soft(at)bdanube(dot)com>, pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: one-to-one |
| Date: | 2003-08-22 01:40:09 |
| Message-ID: | 200308211840.09062.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Michael,
> Thanks Josh, Jason and Adrian for your comments!
> Josh, I'm curious why you refer to a "pseudo-relational model"?
Well, SQL is a very imperfect implementation of relational theory. SQL fails
to implement a lot of Codd's relational calculus, such as distributed keys
and database constraints, as well as making some set operations (such as "is
not a member of" and "is the greatest(col) record of") far more difficult and
inefficient than they need to be.
For more detail on this, see Fabian Pascal's web page, particularly the
articles written by CJ Date:
www.dbdebunk.com
--
-Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kirill Krasnosselov | 2003-08-22 11:31:16 | c-function returns multiple rows |
| Previous Message | Josh Berkus | 2003-08-22 01:21:39 | Re: Database theory (was Re: one-to-one) |