Hi Robert and all, I've been trying to follow the examples on the pg docs, section 5.9, with your presentation as aditional guide. I've bumped into the UPDATES. I'm getting this: ---------------------------------------------------------- CREATE RULE measurement_update_y2004m02 AS ON UPDATE TO measurement WHERE ( logdate >= DATE '2004-02-01' AND logdate < DATE '2004-03-01' ) DO INSTEAD UPDATE INTO measurement_y2004m02 VALUES (NEW.city_id, NEW.logdate, NEW.peaktemp, NEW.unitsales); ERROR: syntax error at or near "INTO" LINE 1: ...D logdate < DATE '2004-03-01' ) DO INSTEAD UPDATE INTO measu... ------------------------------------------------- it doesn't like the INTO part. can you help me? thanks joao On Sat, 2008-09-13 at 16:48 -0400, Robert Treat wrote: > On Thursday 11 September 2008 07:47:00 Joao Ferreira gmail wrote:
