Re: [GENERAL] Functions

On Wed, 3 Nov 1999, Aaron J. Seigo wrote:

> 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

Ok, thanks, I must admit I wasn't really aware of pl/pgsql, so this gives me a
reason to look into it.

Simon.


>

--
 "Linux - open doors, not windows."

   Simon Drabble                      It's like karma for your brain.
   simon@eskimo.com