Postgres Pro
Downloads
Home   >   mailing lists

Re: WHEN NO_DATA_FOUND THEN.... - Mailing list pgsql-novice

From Tom Lane
Subject Re: WHEN NO_DATA_FOUND THEN....
Date
Msg-id 27369.1286300453@sss.pgh.pa.us
Whole thread Raw
In response to WHEN NO_DATA_FOUND THEN....  (Mladen Gogala <mgogala@vmsinfo.com>)
Responses Re: WHEN NO_DATA_FOUND THEN....  (Mladen Gogala <mgogala@vmsinfo.com>)
List pgsql-novice
Tree view 
Mladen Gogala <mgogala@vmsinfo.com> writes:
> Is there any way for Postgres to raise an exception when no data is
> found?

See the SELECT ... INTO STRICT option.

(If you haven't got it, it's time for an update.)

            regards, tom lane

pgsql-novice by date:

Previous
From: Mladen Gogala
Date:
Subject: WHEN NO_DATA_FOUND THEN....
Next
From: Mladen Gogala
Date:
Subject: Re: WHEN NO_DATA_FOUND THEN....