Re: Making query without trigger - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Making query without trigger
Date
Msg-id 20060526181244.GJ5939@phlogiston.dyndns.org
Whole thread Raw
In response to Making query without trigger  (kmi@st.uz)
Responses Re: Making query without trigger
List pgsql-general
On Fri, May 26, 2006 at 12:02:44PM +0500, kmi@st.uz wrote:
> I have trigger on updating the table. Sometimes i need to make queries
> without calling that trigger. How can I solve this?

You need your function to decide whether the "don't do anything"
conditions apply, and then not do anything.  The trigger still fires,
but it doesn't do anything.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
"The year's penultimate month" is not in truth a good way of saying
November.
        --H.W. Fowler

pgsql-general by date:

Previous
From: "P.M"
Date:
Subject: Re: move from 1 database to another
Next
From: "A.M."
Date:
Subject: convert row() to array