Postgres Pro
Downloads
Home   >   mailing lists

Re: How to raise error from PostgreSql SQL statement if some condition is met - Mailing list pgsql-general

From Craig Ringer
Subject Re: How to raise error from PostgreSql SQL statement if some condition is met
Date
Msg-id 50272283.1010205@ringerc.id.au
Whole thread Raw
In response to How to raise error from PostgreSql SQL statement if some condition is met  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
Tree view
On 08/12/2012 03:07 AM, Andrus wrote:
I’m looking for a way to raise error from sql select if some condition is met.
Tried code below to got error shown in comment.
How to fix ?

Create a small pl/pgsql function that RAISEs a message, and call that from your EXECUTEd SQL via a CASE ... WHEN .

--
Craig Ringer

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: How to raise error from PostgreSql SQL statement if some condition is met
Next
From: Craig Ringer
Date:
Subject: Re: How to raise error from PostgreSql SQL statement if some condition is met