It's in the SQL99 standard. There's nothing forcing you to use them - I am a (possibly) old-fashioned data architect, so I never use them ;-)
SQL99 actually allows you to use more or less arbitrary composite types as columns (although Pg currently doesn't) - many would argue that this violates first normal form. OTOH there's probably a good case to make that all this is necessary to provide good support to ObjectRelational mappings, and other OO stuff.
andrew
Dani Oderbolz wrote:
I got another question to this: why does PostgreSQL support Arrays in the first place? For my taste, its a very messy concept...
Regards, Dani
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
