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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-sql by date

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