Re: help w/ SRF function

On Tue, 2007-09-18 at 02:24 -0700, Trevor Talbot wrote:
> On 9/17/07, Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> wrote:
>
> > > > CREATE OR REPLACE FUNCTION foo_func(fromdate timestamp, todate
> > > > timestamp, code text)
>
> > > > LANGUAGE 'sql' IMMUTABLE STRICT;
>
> > > But If I were to use ALIASINg, I get an error
> > >
> > > eg: DECLARE
> > > DECLARE
> > > fromdate ALIAS for $1;
> > > todate ALIAS for $2;
> > > code ALIAS for $3;
> > >
> > >
> > > ERROR: syntax error at or near "ALIAS"
> > > LINE 5: fromdate ALIAS for $1;
>
> > anyone knows how come I can't use the reference fromdate/todate etc or
> > use aliases but have to resort to using $1/$2 etc?
>
> You seem to be confusing SQL with PL/pgSQL. If you want variables,
> aliases, flow control etc instead of a simple macro, you need to use a
> procedural language.
>
> http://www.postgresql.org/docs/8.2/static/xfunc-sql.html
> http://www.postgresql.org/docs/8.2/static/plpgsql.htmll

Thanks. I've moved from SQL to plpgsql now. Thanks to your pointers and
ppl in IRC.