PostgreSQL 7.3: help on new CREATE TYPE

From: "Jerome Chochon" <jerome(dot)chochon(at)ensma(dot)fr>
To: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-announce(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL 7.3: help on new CREATE TYPE
Date: 2002-09-17 09:17:14
Message-ID: 047101c25e2b$038cd0c0$80a337c1@pclisi17
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-09-17 09:25:24 Re: [HACKERS] PostgreSQL 7.3: help on new CREATE TYPE
Previous Message Shridhar Daithankar 2002-09-17 09:10:54 Re: [HACKERS] PGXLOG variable worthwhile?

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-09-17 09:25:24 Re: [HACKERS] PostgreSQL 7.3: help on new CREATE TYPE
Previous Message Shridhar Daithankar 2002-09-17 09:10:54 Re: [HACKERS] PGXLOG variable worthwhile?