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.
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? |
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? |