Обсуждение: how to use composite type

hi,
 I created a composite type as follows, but I couldn't know how to use it.

test=# create type test_type as (id int, name char(20));
CREATE TYPE
test=# create table student( a test_type);
ERROR:  Attribute "a" has composite type test_type

who can tell me? thanks!bigapple
　　　　　　　　
　　　　　　　　　　2002-12-27

You can use it in a function:

CREATE FUNCTION test () returns setof test_type as ...

Chris


> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of bigapple
> Sent: Friday, 27 December 2002 9:57 AM
> To: hacker_mailinglist
> Subject: [HACKERS] how to use composite type
>
>
> hi,
>
>   I created a composite type as follows, but I couldn't know how
> to use it.
>
> test=# create type test_type as (id int, name char(20));
> CREATE TYPE
> test=# create table student( a test_type);
> ERROR:  Attribute "a" has composite type test_type
>
> who can tell me? thanks!
>
>  bigapple
> 　　　　　　　　
> 　　　　　　　　　　2002-12-27
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>