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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
