create type question....

From: Brian OBrien <bobrien18(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: create type question....
Date: 2004-03-04 21:45:43
Message-ID: 20040304214543.24915.qmail@web13704.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I create a data type as follows:

create type baseobject as (grp integer, elem integer,
len integer, dta bytea);

I then wish to make a table of these:

create table image (obj baseobject);

however the table creation fails with this error
message:

ERROR: column "obj" has composite type baseobject

If I can't use composite data types in tables what is
the use of a composite data type?

______________________________________________________________________
Post your free ad now! http://personals.yahoo.ca

Browse pgsql-novice by date

  From Date Subject
Next Message Allan Poulsen 2004-03-05 10:47:21 to_hex question
Previous Message Scott Goodwin 2004-03-04 14:21:24 Re: Merging multiple values into comma-delimited list in a view