Re: [SQL] SQL Spec Compliance Questions

Elein,

> In postgres and Illustra, references were possible.
> That is, storing the OID (REF) of a table in a column of another
> table achieving the same effect.  SQL syntax support
> was needed for the REF type.  I believe this was removed
> or suppressed in PostgreSQL.

Yeah, I'd like to see a return of table references as FKs.   It would allow me
to eliminate all of these rather non-relational integer-based surrogate keys.

I don't think our OIDs would be the way to go on this, given the problems
already discussed with PG OIDs.   I kinda like SyBase's solution, where they
have a system-acessable hash key of the data in the row.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco