Re: How to raise error from PostgreSql SQL statement if some condition is met

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Andrus <kobruleht2(at)hot(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to raise error from PostgreSql SQL statement if some condition is met
Date: 2012-08-12 03:26:59
Message-ID: 50272283.1010205@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2012-08-12 05:07:01 Re: How to raise error from PostgreSql SQL statement if some condition is met
Previous Message Pavel Stehule 2012-08-11 20:46:33 Re: How to raise error from PostgreSql SQL statement if some condition is met