Re: PostgreSQL Functions / PL-Language

From: "Jan Cruz" <malebug(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL Functions / PL-Language
Date: 2006-02-18 08:48:55
Message-ID: 493da2780602180048if76be31w326bf1a51de17564@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pailloncy Jean-Gerard 2006-02-18 09:03:11 Non-Overlaping date interval index
Previous Message Martijn van Oosterhout 2006-02-18 08:31:54 Re: PostgreSQL Functions / PL-Language