From: Richard Huxton <dev@archonet.com>
To: "Jackson, Harold" <harold.jackson@attws.com>, <pgsql-docs@postgresql.org>
Subject: Re: problem with getting return type mismatch from function
Date: Fri, 19 Dec 2003 14:53:48 +0000
User-Agent: KMail/1.5
References: 
 <B8A9DDDC5AF40449ACDC46C952D83C0F0177BFBA@WA-MSG04-BTH.wireless.attws.com>
In-Reply-To: 
 <B8A9DDDC5AF40449ACDC46C952D83C0F0177BFBA@WA-MSG04-BTH.wireless.attws.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200312191453.48358.dev@archonet.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