On 9/25/07, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote: > 2007/9/25, Scott Marlowe <scott.marlowe@xxxxxxxxx>: > > On 9/24/07, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote: > > > 2007/9/25, Rhys Stewart <rhys.stewart@xxxxxxxxx>: > > > > yes indeed. thats exactly it scott!!! > > > > > > > > On 9/24/07, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > > > > > On 9/24/07, Pavel Stehule <pavel.stehule@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/