I've got the following table:
CREATE TABLE alumbrado_puntos_luz ( id numeric(8,0), "GEOMETRY" geometry, revision_actual numeric(10,0), revision_expirada numeric(10,0), CONSTRAINT alumbrado_puntos_luz_id_key UNIQUE (id) ) WITH ( OIDS=TRUE );
When updating the table i would like to update just the revision_expirada value with the next serial and insert the NEW pseudo-record's values in a new record on the same table. I mean, every time i have a change in the drawing (GEOMETRY) i will create a new record with the changes and leave the old one as it is.
I don't know if a trigger is the best way of doing this or creating a rule would be a better idea.