Re: [HACKERS] PostgreSQL 7.3: help on new CREATE TYPE - Mailing list pgsql-general

From Tom Lane
Subject Re: [HACKERS] PostgreSQL 7.3: help on new CREATE TYPE
Date
Msg-id 23647.1032272571@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] PostgreSQL 7.3: help on new CREATE TYPE  ("Jerome Chochon" <jerome.chochon@ensma.fr>)
List pgsql-general
"Jerome Chochon" <jerome.chochon@ensma.fr> writes:
> Can I use this new type like other user-type ?
> CREATE TABLE person (his_name VARCHAR, his_adress adress);
> ...where adress is CREATE TYPE adress AS (number int, street text, country
> VARCHAR);

Not at the moment, though that might be an interesting direction to
pursue in future releases.  At present, the only thing such a type is
useful for is to define the argument or result type of a function that
takes or returns records.

            regards, tom lane

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Still big problems with pg_dump!
Next
From: Wim
Date:
Subject: Re: Still big problems with pg_dump!