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