Postgres Pro
Downloads
Home   >   mailing lists

Re: return setof record - strange behavior - Mailing list pgsql-sql

From Tom Lane
Subject Re: return setof record - strange behavior
Date
Msg-id 4069.1217858360@sss.pgh.pa.us
Whole thread Raw
In response to Re: return setof record - strange behavior  ("Pawel Socha" <pawel.socha@gmail.com>)
List pgsql-sql
Tree view 
"Pawel Socha" <pawel.socha@gmail.com> writes:
> 2008/8/4 Marcin Krawczyk <jankes.mk@gmail.com>
>> Hi everybody. Can anyone enlighten me what's wrong with this function :

> [ you didn't do "RETURN next w;" ]

IIRC the other way is to assign to the output parameters by name, then
do RETURN NEXT with no argument.  But the FOR-loop all by itself isn't
going to return any data to the function's caller.
        regards, tom lane

pgsql-sql by date:

Previous
From: "Mike Gould"
Date:
Subject: Case Insensitive searches
Next
From: "Richard Broersma"
Date:
Subject: Re: Case Insensitive searches