Re: set returning functions.

2007/9/25, Scott Marlowe <scott.marlowe@gmail.com>:
> On 9/24/07, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> > 2007/9/25, Rhys Stewart <rhys.stewart@gmail.com>:
> > > yes indeed. thats exactly it scott!!!
> > >
> > > On 9/24/07, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> > > > On 9/24/07, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> > > > > Hello Rhys
> > > > >
> > > > > its not mystery
> > > >
> > > > Yeah, but I think he wanted to be able to make his own function he
> > > > could call like:
> > > >
> > > > select myfunc(10);
> > > >
> >
> > Then you have to use sql language
> >
> > create or replace function mysrf(int)
> > returns setof integer as $$
> > select i from generate_series(1, $1) g(i);
> > $$ language sql;
>
> Do you HAVE to use sql plsql to get this to work?  I thought that all
> pl languages worked like this with pgsql.
>

if you can call SRF function in normal context (like SELECT srf()),
you have to use SQL language

Pavel