Functions

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