Greg Stark <[EMAIL PROTECTED]> writes: > If I understand what you're talking about, you would be allowed to > CREATE TYPE a composite type, like say, "address" and then use that as > a datatype all over your database? And then if you find "address" > needs a new field you can add it to the type and automatically have it > added all over your database to any table column using that type?
I believe that would work, though you might have some issues with cached plans. > How will client programs see the data if i do a "select *"? TBD. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html