Thread: 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 >