Re: Rule problem: return value of insert

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephen Friedrich <stephen(dot)friedrich(at)fortis-it(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Rule problem: return value of insert
Date: 2006-01-17 20:59:45
Message-ID: 21454.1137531585@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Stephen Friedrich <stephen(dot)friedrich(at)fortis-it(dot)de> writes:
> Or do you mean that the last rule that
> gets evaluated will determine the result, even if it's where clause evaluates
> to false?

Right. In effect, the last one in alphabetical order will always
determine the result, whether it's the one that does the useful insert
or not.

> Thanks I'll try that. Yet I have only some dozen cdrs at any time, so
> I doubt it will make a big difference?

Perhaps not, but it's worth checking.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Casanova 2006-01-17 21:19:25 Re: [GENERAL] migrar
Previous Message David Rysdam 2006-01-17 20:37:14 prepared statement results don't clear?