how to use composite type - Mailing list pgsql-hackers

From bigapple
Subject how to use composite type
Date
Msg-id 20021227015613.52F291CFE10DB@sm203.163.com
Whole thread Raw
Responses Re: how to use composite type
List pgsql-hackers
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





pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Postgres is ignoring TCL_INCLUDE_SPEC
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: how to use composite type