pl/pythonu and Triggers

Поиск
Список
Период
Сортировка
От C G
Тема pl/pythonu and Triggers
Дата
Msg-id LAW12-F18Xg5wlSe9F60000288b@hotmail.com
обсуждение исходный текст
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: psql's "\d" and CLUSTER
Следующее
От: Francois Suter
Дата:
Сообщение: Re: Anyone has nls activated on Mac OS X?