On Mon, Sep 15, 2008 at 11:48:49PM +0100, Joao Ferreira gmail wrote: > 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 João, Rules are not how you want to do this anyhow. Write triggers :) Cheers, David. -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate
