You can use it in a function: CREATE FUNCTION test () returns setof test_type as ...
Chris > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]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 > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
