Re: [GENERAL] Functions - Mailing list pgsql-general

From Simon Drabble
Subject Re: [GENERAL] Functions
Date
Msg-id Pine.LNX.4.10.9911031707050.21341-100000@dragon.localdomain
Whole thread Raw
In response to Re: [GENERAL] Functions  ("Aaron J. Seigo" <aaron@gtv.ca>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Aaron J. Seigo"
Date:
Subject: Re: [GENERAL] Functions
Next
From: Simon Drabble
Date:
Subject: Re: [GENERAL] Functions