"Walter Mesz" <meszwalter(at)yahoo(dot)de> writes:
> my problem is that this select into does not throw a NO_DATA_FOUND if my
> select involves a max().
Well, a query using max() (or any other aggregate) is defined to return
exactly one row, independently of how many rows feed into the max().
So I'm not sure why you'd think that it should throw NO_DATA_FOUND.
If you want to test for not finding any rows in the underlying scan,
the best way would be to also compute count(*) and check if that's
zero.
regards, tom lane