On Sat, 2007-02-06 at 14:25 +0200, Frank van Vugt wrote:
> BEGIN;
> SELECT * INTO STRICT myrec FROM emp WHERE empname = myname;
> EXCEPTION
> WHEN NO_DATA_FOUND THEN
> RAISE EXCEPTION 'employee % not found', myname;
> WHEN TOO_MANY_ROWS THEN
> RAISE E
Hi,
I noticed that the example code for SELECT STRICT mentioned in the docs
(v8.2.4) under "37.6.3. Executing a Query with a Single-Row Result" mentions:
BEGIN;
SELECT * INTO STRICT myrec FROM emp WHERE empname = myname;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RAISE EXCEPTI