Skip site navigation (1) Skip section navigation (2)

Re: Trouble with composite types

From: Joe Conway <mail(at)joeconway(dot)com>
To: Yasir Malik <ymalik(at)cs(dot)stevens-tech(dot)edu>
Cc: PostgreSQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Trouble with composite types
Date: 2004-02-29 23:35:57
Message-ID: 4042775D.5060007@joeconway.com (view raw or flat)
Thread:
Lists: pgsql-sql
Yasir Malik wrote:
[attempts to use a composite type as a field data type of another
  composite type]
> 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?

What you are trying to do is currently unsupported. There have been 
multiple discussions in the past on this -- try searching the archives 
for more info.

Joe


In response to

pgsql-sql by date

Next:From: Abdul Wahab DahalanDate: 2004-03-01 02:06:25
Subject: How to get Rows Count
Previous:From: Joe ConwayDate: 2004-02-29 23:32:40
Subject: Re: plpgsql function returning SETOF RECORD Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group