Il sab, 2003-12-13 alle 15:48, Chris Travers ha scritto:
> Or, depending if you just want to ignore updates to that field (not
> always best, but possible, similar to a view).
>
> CREATE OR REPLACE FUNCTION block_col()
> RETURNS TRIGGER AS '
> BEGIN
> NEW.ts_field := OLD.ts_field;
> RETURN NEW;
> END;
> ' LANGUAGE PLPGSQL;
>
Great. It works exactly as I need.
(notice: I had to replace RETURNS TRIGGER with RETURNS OPAQUE)
Thanks everybody,
Claudio
--
Claudio Succa
PERTEL - Torino - Italy
+39-011-437.4141
http://www.pertel.it
http://www.uniassist.it