Postgres Pro
Downloads
Home   >   mailing lists

Re: How to NOT perform an insert - Mailing list pgsql-novice

From Tom Lane
Subject Re: How to NOT perform an insert
Date
Msg-id 4466.1055972192@sss.pgh.pa.us
Whole thread Raw
In response to How to NOT perform an insert  ("Fontenot, Paul" <Paul.Fontenot@bannerhealth.com>)
List pgsql-novice
Tree view 
"Fontenot, Paul" <Paul.Fontenot@bannerhealth.com> writes:
> Can I prevent an insert based on what is in a particular field?

Yeah, a BEFORE INSERT trigger can cause the insertion to be skipped
--- just return NULL, instead of returning the row to insert as you'd
normally do.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Juliet May"
Date:
Subject: Re: Documentation Tools
Next
From: Lynna Landstreet
Date:
Subject: "Bad date external representation"