Re: [GENERAL] Functions

hi...

> CREATE FUNCTION fn_fubar(int4) AS
> 'UPDATE foo SET bar = tmp.numb FROM tmp WHERE tmp.numb = $$'
> LANGUAGSE 'sql';

i hate $1, $2 personally.. they make my eyes cross eventually (esp. once you
have 3 or 4 params.. ick) and they are hard to maintain in larger functions
(what was that $2 param again???)

so i usually use pl/pgsql and do this:

CREATE FUNCTION fn_fubar(int4) returns int4 AS '
DECLARE
myParam alias for $1;
BEGIN
UPDATE foo SET bar = tmp.numb FROM tmp WHERE tmp.numb = myParam;
return myParam;
END; '
LANGUAGSE 'pl/pgsql';

more typing, but easier to read and maintain later... but then, i'm picky.

--
Aaron J. Seigo
Sys Admin