Richard,
you are right! It was early in the morning... :)
Thank you!
--csaba együd
> -----Original Message-----
> From: Richard Huxton [mailto:dev@archonet.com]
> Sent: 2004. április 15. 9:31
> To: csegyud@vnet.hu; Pgsql-General@Postgresql.Org (E-mail)
> Subject: Re: [GENERAL] 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
> -- Incoming mail is certified Virus Free.
> Checked by AVG Anti-Virus (http://www.grisoft.com).
> Version: 7.0.230 / Virus Database: 262 - Release Date: 2004. 04. 15.
>