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(at)eskimo(dot)com