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
Show quoted text
-----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 typehi,
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_typewho can tell me? thanks!
bigapple
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷2002-12-27---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?