Re: [HACKERS] PostgreSQL 7.3: help on new CREATE TYPE

Sorry if my english is not very good. ;-).

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);

Thanks for your reply ?

----- Original Message -----
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-announce(at)postgresql(dot)org>;
<pgsql-general(at)postgresql(dot)org>
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 used for writing stored procedures and functions that
> return sets.
>
> eg. CREATE FUNCTION foo() RETURNS setof adress
> AS '...';
>
> Sort of thing...
>
> Chris
> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org]On Behalf Of Jerome Chochon
> Sent: Tuesday, 17 September 2002 5:17 PM
> To: pgsql-hackers(at)postgresql(dot)org; pgsql-announce(at)postgresql(dot)org;
> pgsql-general(at)postgresql(dot)org
> 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.
>
> 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.
>