Re: [HACKERS] how to use composite type

2002-12-26 Thread Christopher Kings-Lynne
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: [H

[HACKERS] how to use composite type

2002-12-26 Thread bigapple
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 ยก