Re: SRF problem - Mailing list pgsql-general

From Együd Csaba
Subject Re: SRF problem
Date
Msg-id 001801c422bc$9cdf1c40$230a0a0a@compaq
Whole thread Raw
In response to Re: SRF problem  (Richard Huxton <dev@archonet.com>)
List pgsql-general
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.
>


pgsql-general by date:

Previous
From: Holger Klawitter
Date:
Subject: Re: SRF problem
Next
From: vickr1z@operamail.com
Date:
Subject: SQL script