"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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org