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




Fri, 27 Dec 2002 9:56:58 +0800
"bigapple" <bigapple__2002@163.com>
how to use composite type
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
>


Fri, 27 Dec 2002 10:00:28 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: how to use composite type