Re: [GENERAL] on insert when ... do instead update

2008-03-16 Thread Tom Lane
askel <[EMAIL PROTECTED]> writes: > Hello everybody! > I'm having problem with postgresql 8.3 (not sure if it is related to > this particular version). Suppose we have accounting system database > with the following rule (no other rules are there): > create or replace rule update_or_create_balance

[GENERAL] on insert when ... do instead update

2008-03-16 Thread askel
Hello everybody! I'm having problem with postgresql 8.3 (not sure if it is related to this particular version). Suppose we have accounting system database with the following rule (no other rules are there): create or replace rule update_or_create_balance as on insert to ledger when exists (select