Re: rules on INSERT can't UPDATE new instance?

>
>  From the create_rule man page this example is offered:
>
>   CREATE RULE example_5 AS
>            ON INERT TO emp WHERE new.salary > 5000
>            DO
>             UPDATE NEWSET SET salary = 5000;
>
> But what is "NEWSET"? Is it a keyword?

It should be:

CREATE RULE example_5 AS
    ON INERT TO emp WHERE new.salary > 5000
    DO
        UPDATE emp SET salary = 5000
        WHERE emp.oid = new.oid;

Fixing now.

>
> My problem is that on an insert with an invalid amount I try to perform
> an update with a corrected amount, but the action part of the rule
> doesn't affect or "see" the newly inserted row (or so it seems).
>
> I tried: CREATE RULE ON INSERT TO bid WHERE new.price > limit
>          DO UPDATE bid SET price = 0.1;
>
> and all price columns in the bid table would be set to 0.1 _except_ the
> newly inserted row.
>
> Am I missing something obvious?

No, buggy documentation.  My book has a section on rules too, but you
should be fine now.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026