Thread: problem with getting return type mismatch from function

problem with getting return type mismatch from function

From
"Jackson, Harold"
Date:
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? 
 

Harold A. Jackson

DBA

NDCO

AT&T Wireless Services

(425)288-3485 (desk)

(425)241-8092 (cell)

harold.jackson@attws.com

 

 

 
Attachment

Re: problem with getting return type mismatch from function

From
"Peter Eisentraut"
Date:
Jackson, Harold writes:
> Any ideas?

No.  This list is for discussing documentation issues.




Re: problem with getting return type mismatch from function

From
Richard Huxton
Date:
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