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