Re: max() unexpected type conversion

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hélder M(dot) Vieira <hmv(at)mail(dot)telepac(dot)pt>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: max() unexpected type conversion
Date: 2005-11-21 15:03:45
Message-ID: 1719.1132585425@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"=?iso-8859-1?Q?H=E9lder_M._Vieira?=" <hmv(at)mail(dot)telepac(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message stig erikson 2005-11-21 20:16:13 Re: A Not Join
Previous Message Hélder M. Vieira 2005-11-21 12:47:40 max() unexpected type conversion