[GENERAL] Functions

[Simon Drabble]

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.
   [EMAIL PROTECTED]


************