Re: [GENERAL] Functions

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@demog.berkeley.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@eskimo.com
>
>
> ************
>