Greg Stark <gsstark(at)mit(dot)edu> 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