how to use composite type

From: "bigapple" <bigapple__2002(at)163(dot)com>
To: hacker_mailinglist <pgsql-hackers(at)postgresql(dot)org>
Subject: how to use composite type
Date: 2002-12-27 01:56:58
Message-ID: 20021227015613.52F291CFE10DB@sm203.163.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-12-27 02:00:28 Re: how to use composite type
Previous Message Tom Lane 2002-12-26 22:29:18 Postgres is ignoring TCL_INCLUDE_SPEC