Re: [BUGS] BUG #5105: "Select Into Strict" does not throw NO_DATA_FOUND

2009-10-08 Thread Kevin Grittner
"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

Re: [BUGS] BUG #5105: "Select Into Strict" does not throw NO_DATA_FOUND

2009-10-08 Thread Tom Lane
"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

[BUGS] BUG #5105: "Select Into Strict" does not throw NO_DATA_FOUND

2009-10-08 Thread Walter Mesz
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