Trouble with composite types

From: Yasir Malik <ymalik(at)cs(dot)stevens-tech(dot)edu>
To: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Trouble with composite types
Date: 2004-02-29 20:22:01
Message-ID: Pine.NEB.4.58.0402291520050.4735@dab.cs.stevens-tech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,
I don't know why this message is not going through!

I have the following types:
create type street_type as
(
street_number smallint,
street_name text,
apt_number smallint
);

create type address_type as
(
street street_type,
city text,
state char(2),
zip_code char(5)
);

When I enter that into the command prompt, I the following message:
ERROR: Attribute "street" has composite type street_type

Why is it giving me error message for something I know is true? Also, how
do I add a member function to a type?
Thanks,
Yasir

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message rixder 2004-02-29 20:48:18 Re: Field list from table
Previous Message Tom Lane 2004-02-29 15:11:48 Re: returning a recordset from PLpg/SQL