On Thursday 15 April 2004 07:51, Együd Csaba wrote:
> Hi All,
> I'd like to write an SRF but I'm block a strange error message
>
> WARNING: plpgsql: ERROR during compile of check_close2 near line 11
> ERROR: return type mismatch in function returning tuple at or near ";"
> create or replace function check_close2() returns CHECK_CLOSE AS '
This should be SET OF CHECK_CLOSE, remember you're calling the function like:
SELECT * FROM check_close2()
rather than:
SELECT check_close2()
So the return-type needs to be "set of" even if only returning one value.
--
Richard Huxton
Archonet Ltd