Adriaan van Os wrote: > >> 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.
Aside from the apparent discrepancy between the documentation and the actual behavior, is there an actual use case where this is a problem? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match