problem with getting return type mismatch from function

Jackson, Harold writes:

Any ideas?

No. This list is for discussing documentation issues.

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