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: 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. > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
