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