Re: set returning functions.

On 9/25/07, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> 2007/9/25, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>:
> > On 9/24/07, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
> > > 2007/9/25, Rhys Stewart <rhys(dot)stewart(at)gmail(dot)com>:
> > > > yes indeed. thats exactly it scott!!!
> > > >
> > > > On 9/24/07, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> > > > > On 9/24/07, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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

You can also do this in a C function also. you can always wrap your
plpgsql function in an sql function and sneak around the problem.
That said, it would be extremely nice if pl/pgsql functions could work
this way.

merlin