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

Re: problem with getting return type mismatch from function

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Jackson, Harold" <harold(dot)jackson(at)attws(dot)com>,<pgsql-docs(at)postgresql(dot)org>
Subject: Re: problem with getting return type mismatch from function
Date: 2003-12-19 14:53:48
Message-ID: 200312191453.48358.dev@archonet.com (view raw or flat)
Thread:
Lists: pgsql-docs
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

In response to

pgsql-docs by date

Next:From: Bruce MomjianDate: 2003-12-19 23:58:15
Subject: Re: My SGML build fixed
Previous:From: Tom LaneDate: 2003-12-18 16:57:35
Subject: Re: My SGML build fixed

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