Re: [HACKERS] PostgreSQL 7.3: help on new CREATE TYPE

"Jerome Chochon" <jerome(dot)chochon(at)ensma(dot)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