Re: SRF problem

From: Együd Csaba <csegyud(at)vnet(dot)hu>
To: 'Richard Huxton' <dev(at)archonet(dot)com>, "'Pgsql-General(at)Postgresql(dot)Org (E-mail)'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: SRF problem
Date: 2004-04-15 07:38:15
Message-ID: 001801c422bc$9cdf1c40$230a0a0a@compaq
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Richard,
you are right! It was early in the morning... :)

Thank you!
--csaba együd

> -----Original Message-----
> From: Richard Huxton [mailto:dev(at)archonet(dot)com]
> Sent: 2004. április 15. 9:31
> To: csegyud(at)vnet(dot)hu; Pgsql-General(at)Postgresql(dot)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.
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message vickr1z 2004-04-15 08:22:06 SQL script
Previous Message Holger Klawitter 2004-04-15 07:35:18 Re: SRF problem