On Tue, 2007-09-18 at 02:24 -0700, Trevor Talbot wrote: > On 9/17/07, Ow Mun Heng <Ow.Mun.Heng@xxxxxxx> 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. ---------------------------(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
