From: Richard Huxton <dev@archonet.com>
To: Jackson, Harold <harold.jackson@attws.com>
To: pgsql-docs@postgresql.org
Subject: Re: problem with getting return type mismatch from function
Date: Fri, 19 Dec 2003 14:53:48 +0000
Message-ID: <200312191453.48358.dev@archonet.com> (raw)
In-Reply-To: <B8A9DDDC5AF40449ACDC46C952D83C0F0177BFBA@WA-MSG04-BTH.wireless.attws.com>
References: <B8A9DDDC5AF40449ACDC46C952D83C0F0177BFBA@WA-MSG04-BTH.wireless.attws.com>
On Thursday 18 December 2003 02:44, Jackson, Harold wrote:
> Hi,
> I'm having a problem with a function that I'm trying to create. I
> created a data type that is composed of fields from 2 different tables.
> When I create SQL functions this seems to work just fine. However,
> when I try to use this data type in a plpgsql function, I get the error
> message
> " return type mismatch in function returning tuple at or near
> "type_name"". No way is what I created a tuple. We're running
> PostgreSQL 7.3.2 on Red Hat Linux. Any ideas?
To expand on Peter's note - try the general or sql lists. You'll need to
supply the code from the function too, otherwise no-one can help.
--
Richard Huxton
Archonet Ltd
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-docs@postgresql.org
Cc: dev@archonet.com, harold.jackson@attws.com
Subject: Re: problem with getting return type mismatch from function
In-Reply-To: <200312191453.48358.dev@archonet.com>
* 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