From: Yasir Malik <ymalik@cs.stevens-tech.edu>
To: PostgreSQL <pgsql-sql@postgresql.org>
Subject: Trouble with composite types
Date: Sun, 29 Feb 2004 15:22:01 -0500 (EST)
Message-ID: <Pine.NEB.4.58.0402291520050.4735@dab.cs.stevens-tech.edu> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ymalik@cs.stevens-tech.edu
Subject: Re: Trouble with composite types
In-Reply-To: <Pine.NEB.4.58.0402291520050.4735@dab.cs.stevens-tech.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox