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. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
