From: | Andrew Perrin - Demography <aperrin(at)demog(dot)berkeley(dot)edu> |
---|---|
To: | Simon Drabble <simon(at)eskimo(dot)com> |
Cc: | Postgres Group <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] Functions |
Date: | 1999-11-03 21:04:30 |
Message-ID: | Pine.SUN.4.10.9911031303400.21325-100000@davis.DEMOG.berkeley.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I believe it's $1, $2, etc., so it would be:
> CREATE FUNCTION fn_fubar(int4) AS
> 'UPDATE foo SET bar = tmp.numb FROM tmp WHERE tmp.numb = $1'
> LANGUAGSE 'sql';
---------------------------------------------------------------------
Andrew J. Perrin - aperrin(at)demog(dot)berkeley(dot)edu - NT/Unix Admin/Support
Department of Demography - University of California at Berkeley
2232 Piedmont Avenue #2120 - Berkeley, California, 94720-2120 USA
http://demog.berkeley.edu/~aperrin --------------------------SEIU1199
On Wed, 3 Nov 1999, Simon Drabble wrote:
> Ok, following on from the previous stuff, I'm now trying to put that update
> into a function. How can I reference the passed parameter(s)?
>
> CREATE FUNCTION fn_fubar(int4) AS
> 'UPDATE foo SET bar = tmp.numb FROM tmp WHERE tmp.numb = $$'
> LANGUAGSE 'sql';
>
> where $$ would be the parameter passed to the function:
>
> SELECT fn_fubar(20);
>
>
> Simon
> Buying a SQL book this weekend :)
>
>
>
> --
> "Linux - open doors, not windows."
>
> Simon Drabble It's like karma for your brain.
> simon(at)eskimo(dot)com
>
>
> ************
>
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Perkins | 1999-11-03 21:08:00 | PHP4 Review "Brand New" Its Hot! |
Previous Message | Stuart Woolford | 1999-11-03 20:54:51 | indexed regex select optimisation missing? |