Re: [SQL] abstract data types?

2001-01-20 Thread Brett W. McCoy
On Sat, 20 Jan 2001, Tom Lane wrote: > None, I fear. The stuff you are fooling with is leftover from the old > PostQuel language. Most of it is suffering from bit rot, because the > developers' focus has been on SQL92 compliance for the last six or seven > years. I hadn't realized that SQL99 h

Re: [SQL] abstract data types?

2001-01-20 Thread Tom Lane
John Reid <[EMAIL PROTECTED]> writes: > I'm trying to figure out what support PostgreSQL offers for SQL99 > abstract data types. None, I fear. The stuff you are fooling with is leftover from the old PostQuel language. Most of it is suffering from bit rot, because the developers' focus has bee

[SQL] abstract data types?

2001-01-20 Thread John Reid
Hi all, I'm sure this has become somewhat of a FAQ recently, but I couldn't find any reference to casting composite types in the mailing lists. I'm trying to figure out what support PostgreSQL offers for SQL99 abstract data types. PostgreSQL version is cvs from about a week ago. Given the

Re: [SQL] unreferenced primary keys: garbage collection

2001-01-20 Thread Jan Wieck
Forest Wilkinson wrote: > I have a database in which five separate tables may (or may not) reference > any given row in a table of postal addresses. I am using the primary / > foreign key support in postgres 7 to represent these references. > > My problem is that, any time a reference is removed