> When I say that the second form of CREATE TYPE allow you to make > RECORD type > like RECORD, i don't want to speak about the record in PlPgsql but RECORD > from programming language like ADA or C (typedef struct). > > So the real question is: > 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);
No. By the way - the pgsql-announce list is not for asking quetsions in! Chris ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])