pl/pythonu and Triggers

Started by C Gabout 22 years ago1 messagesgeneral
Jump to latest
#1C G
csgcsg39@hotmail.com

Dear All,

I'm trying to use pythonu and triggers, but can't seem to get it to work.
Could someone give me an example of it in action. For example, could someone
supply the CODE in the function below that ignores whatever is inserted and
puts in 'hello' 'World' instead?

Thanks

Colin

CREATE TABLE t1 (col1 text, col2 text);

CREATE FUNCTION simple() RETURNS TRIGGER AS'
CODE
'LANGUAGE plpythonu;

CREATE TRIGGER simple BEFORE insert
on t1 FOR EACH ROW EXECUTE
PROCEDURE simple();

_________________________________________________________________
Stay in touch with absent friends - get MSN Messenger
http://www.msn.co.uk/messenger