Re: Rule problem: return value of insert - Mailing list pgsql-general

From Tom Lane
Subject Re: Rule problem: return value of insert
Date
Msg-id 21454.1137531585@sss.pgh.pa.us
Whole thread Raw
In response to Re: Rule problem: return value of insert  (Stephen Friedrich <stephen.friedrich@fortis-it.de>)
List pgsql-general
Stephen Friedrich <stephen.friedrich@fortis-it.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

pgsql-general by date:

Previous
From: David Rysdam
Date:
Subject: prepared statement results don't clear?
Next
From: Vishal Dixit
Date:
Subject: pg_dump throws no buffer space available error