From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | "Jerome Chochon" <jerome(dot)chochon(at)ensma(dot)fr>, <pgsql-hackers(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] PostgreSQL 7.3: help on new CREATE TYPE |
Date: | 2002-09-18 01:17:47 |
Message-ID: | GNELIHDDFBOCMGBFGEFOIEEFCEAA.chriskl@familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas O'Dowd | 2002-09-18 02:02:14 | Re: Help! |
Previous Message | Martijn van Oosterhout | 2002-09-17 23:24:48 | Re: find overlapping address ranges |
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2002-09-18 01:25:32 | Re: RPMS for 7.3 beta. |
Previous Message | Bruce Momjian | 2002-09-17 22:36:37 | Re: PGXLOG variable worthwhile? |