Re: max() unexpected type conversion - Mailing list pgsql-sql

From Tom Lane
Subject Re: max() unexpected type conversion
Date
Msg-id 1719.1132585425@sss.pgh.pa.us
Whole thread Raw
In response to max() unexpected type conversion  (Hélder M. Vieira <hmv@mail.telepac.pt>)
List pgsql-sql
"Hélder M. Vieira" <hmv@mail.telepac.pt> writes:
> If max() operates on a 'varchar' type column, the result appears with 'text' 
> type.
> Should I expect this behaviour in the current and later versions ?

This is true of just about everything, not only max() -- there are *no*
functions yielding varchar in recent PG releases.
        regards, tom lane


pgsql-sql by date:

Previous
From: Hélder M. Vieira
Date:
Subject: max() unexpected type conversion
Next
From: george young
Date:
Subject: tid_le comparison for tuple id (ctid) values?