Re: composite types in 7.3

From: Jeff Davis <list-pgsql-general(at)empires(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: composite types in 7.3
Date: 2002-10-01 00:53:43
Message-ID: 200209301753.43143.list-pgsql-general@empires.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-10-01 05:15:10 OS X loader failure (was Re: Beta2 - A Late Announcement)
Previous Message Williams, Travis L, NPONS 2002-10-01 00:08:11 Vacuum question..