PostgreSQL 7.3: help on new CREATE TYPE

Hi all.

 

I have read the last version of PostgreSQL (7.3 beta) and found that the second version of CREATE TYPE is very interesting.

 

So we can create a type that look like a RECORD.

For example:

CREATE TYPE adress AS (number int, street text, country VARCHAR);

 

But can i use this type in a table definition like this:

CREATE TABLE person (his_name VARCHAR, his_adress adress);

 

Someone can answer to my question.

 

Thanks for your help.

 

Jérôme Chochon.