Re: Trouble with composite types - Mailing list pgsql-sql

From Joe Conway
Subject Re: Trouble with composite types
Date
Msg-id 4042775D.5060007@joeconway.com
Whole thread Raw
In response to Trouble with composite types  (Yasir Malik <ymalik@cs.stevens-tech.edu>)
List 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



pgsql-sql by date:

Previous
From: Joe Conway
Date:
Subject: Re: plpgsql function returning SETOF RECORD Question
Next
From: Abdul Wahab Dahalan
Date:
Subject: How to get Rows Count