Re: composite types in 7.3 - Mailing list pgsql-general

From Jeff Davis
Subject Re: composite types in 7.3
Date
Msg-id 200209301753.43143.list-pgsql-general@empires.org
Whole thread Raw
In response to Re: composite types in 7.3  (Joe Conway <mail@joeconway.com>)
List pgsql-general
> Not at the moment. In fact, as of current (meaning by the time beta3 is
> packaged up, if it's not already this way in beta2) cvs you'll get:
>
> test=# create type mytype as (a int, b text);
> CREATE TYPE
> test=# create table mytable(x mytype,y int);
> ERROR:  Attribute "x" has composite type mytype
>
> There have been brief discussions of allowing composite types as table
> column data types in some future release, but nothing serious yet.

I don't have any particular need for that feature, but I found it interesting.
I imagine that if the feature did exist like that, it would require a lot of
extra syntax for the queries.

Thanks,
    Jeff


pgsql-general by date:

Previous
From: "Williams, Travis L, NPONS"
Date:
Subject: Vacuum question..
Next
From: Tom Lane
Date:
Subject: OS X loader failure (was Re: Beta2 - A Late Announcement)