Re: SQL Spec Compliance Questions

Joe,

Thanks for your help!

> 4.16.2 Referenceable tables, subtables, and supertables
>         A table BT whose row type is derived from a structured type ST is
>         called a typed table. Only a base table or a view can be a typed
>         table. A typed table has columns corresponding, in name and
>         declared type, to every attribute of ST and one other column REFC
>         that is the self-referencing column of BT; let REFCN be the
>
> I really don't quite understand this, but I don't think we have it ;-)

Ye Gods and Little Fishes!!

Was the SQL99 Committee smoking crack, or what?    What the heck is that
*for*?

--
Josh Berkus
Aglio Database Solutions
San Francisco