create type question.... - Mailing list pgsql-novice

From Brian OBrien
Subject create type question....
Date
Msg-id 20040304214543.24915.qmail@web13704.mail.yahoo.com
Whole thread Raw
List 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

pgsql-novice by date:

Previous
From: Scott Goodwin
Date:
Subject: Re: Merging multiple values into comma-delimited list in a view
Next
From: Josh Berkus
Date:
Subject: Re: Postgresql.conf help