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 [email protected]
Whole thread Raw
In response to Re: [HACKERS] PostgreSQL 7.3: help on new CREATE TYPE  ("Jerome Chochon" <[email protected]>)
List pgsql-general
"Jerome Chochon" <[email protected]> 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!