Illustra did a very nice job with "composite types" which
correspond to these record types. The composite types
were able to be used as a column type as jerome describes.
The subcolumns were accessed with dots. This gave us
schema.table.column.attribute
where of course attribute could i
> 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 ?
> C
"Jerome Chochon" <[EMAIL PROTECTED]> writes:
> 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);
Not at the moment, though that might be an interestin
CTED]>
To: "Jerome Chochon" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Tuesday, September 17, 2002 11:25 AM
Subject: RE: [HACKERS] PostgreSQL 7.3: help on new CREATE TYPE
> Hi Jerome,
>
> The RECORD type is use
ochon
Sent: Tuesday, 17 September 2002 5:17 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: [HACKERS] 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.
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
