Re: about partitioning
От | Joao Ferreira gmail |
---|---|
Тема | Re: about partitioning |
Дата | |
Msg-id | 1221518929.7104.5.camel@jmf-ubuntu обсуждение исходный текст |
Ответ на | Re: about partitioning (Robert Treat <robert@omniti.com>) |
Ответы |
Re: about partitioning
Re: about partitioning |
Список | pgsql-general |
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:
В списке pgsql-general по дате отправления: