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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
