On Sat, Sep 26, 2009 at 12:35 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Stefan" <sb@drbott.de> writes:
>> The problem is that if it is no record in the table, it seems that first=
the
>> INSERT command is issued and after that the UPDATE command is issued, to=
o.
>
> Well, yeah. =A0That's exactly how it's documented to work: an ON INSERT
> rule is executed after the INSERT proper.
I'm confused. DO INSTEAD doesn't mean DO INSTEAD?
> You could maybe make this work with a BEFORE INSERT trigger.
I'm not sure you can make it reliable though.
...Robert