Peter Gulutzan wrote: > The August draft of the SQL:200n standard (9075-2 Foundation) says in > Section 4.17.2: "Every table constraint specified for base table T is > implicitly a constraint on every subtable of T, by virtue of the fact > that every row in a subtable is considered to have a corresponding > superrow in every one of its supertables."
Yep, this is where we are stuck; having an index span multiple tables in some way. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])