"Walter Mesz" <[email protected]> wrote: > my problem is that this select into does not throw a NO_DATA_FOUND > if my select involves a max(). I did not see this behaviour > documented anywhere and could not find it in a reasonable time at > google. > SELECT max(tanum) > INTO STRICT x > FROM lo_prod_req > WHERE tanum = '1234567'; The documentation says: $ If the STRICT option is specified, the query must return exactly one $ row or a run-time error will be reported http://www.postgresql.org/docs/8.3/interactive/plpgsql-statements.html In this case the query will always return one row. The row may have a NULL if no matching values were found, but the row will be there. select max(x) from (select generate_series(1,10) as x) y where x > 10; max -----
(1 row) Not a bug. -Kevin -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
