"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