On Thursday 18 December 2003 02:44, Jackson, Harold wrote:
> 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
> " 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.
In response to
pgsql-docs by date
|Next:||From: Bruce Momjian||Date: 2003-12-19 23:58:15|
|Subject: Re: My SGML build fixed|
|Previous:||From: Tom Lane||Date: 2003-12-18 16:57:35|
|Subject: Re: My SGML build fixed |