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;
Regards
Pavel Stehule
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
