Re: SRF problem

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