Re: PostgreSQL Functions / PL-Language - Mailing list pgsql-general

From Jan Cruz
Subject Re: PostgreSQL Functions / PL-Language
Date
Msg-id 493da2780602180048if76be31w326bf1a51de17564@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL Functions / PL-Language  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: PostgreSQL Functions / PL-Language  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general


> Why does my stored function returns only the first row of the query instead
> of the whole set of query?

Did you declare your function to return "setof <whatever>" ?

I did but I don't know if I have to iterate/loop and use "return next setof_foo"
or just use return next as it is.


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: PostgreSQL Functions / PL-Language
Next
From: Pailloncy Jean-Gerard
Date:
Subject: Non-Overlaping date interval index