Bruce Momjian wrote:
Adriaan van Os wrote:
The following bug has been logged online:
Bug reference: 2905
Logged by: Adriaan van Os
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: Mac OS X 10.4.6, intel
Description: min and max return incorrect text type
Details:
Table 9-37. Aggregate Functions in the Postgres docs states that the return
type for min and max is the "same as argument type".
However, min(VARCHAROID) and max(VARCHAROID) return TEXTOID as a result
type.
Yea, they are internally treated as very similar types.
But "internally treated as very similar" is still not "same as argument type". Computing requires
exactness.
Adriaan van OS
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
