"Walter Mesz" 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
>FRO
"Walter Mesz" 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
The following bug has been logged online:
Bug reference: 5105
Logged by: Walter Mesz
Email address: meszwal...@yahoo.de
PostgreSQL version: 8.4.0
Operating system: Windows XP SP2
Description:"Select Into Strict" does not throw NO_DATA_FOUND
Details:
Hi,
my problem