Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrus
Subject How to raise error from PostgreSql SQL statement if some condition is met
Date
Msg-id 9E0A5B8931B849A4844AE348C4A0CC34@dell2
Whole thread Raw
Responses Re: How to raise error from PostgreSql SQL statement if some condition is met  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: How to raise error from PostgreSql SQL statement if some condition is met  (Craig Ringer <ringerc@ringerc.id.au>)
Re: How to raise error from PostgreSql SQL statement if some condition is met  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-general
Tree view
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 ?
 
Andrus
 
    CREATE OR REPLACE FUNCTION "exec"(text)
      RETURNS text AS
    $BODY$
        BEGIN
          EXECUTE $1;
          RETURN $1;
        END;
    $BODY$
      LANGUAGE plpgsql VOLATILE;
     
    -- ERROR:  syntax error at or near "raise"
    -- LINE 1: raise 'test'
   
    select exec('raise ''test'' ') where true -- in real application true is replaced by some condition

pgsql-general by date:

Previous
From: Dan Halbert
Date:
Subject: Re: select distinct in a subquery bug/problem
Next
From: Pavel Stehule
Date:
Subject: Re: How to raise error from PostgreSql SQL statement if some condition is met