Re: [SQL] max() unexpected type conversion

2005-11-21 Thread Hélder M . Vieira
This is true of just about everything, not only max() -- there are *no* functions yielding varchar in recent PG releases Thanks for the information. I added an explicit cast to the max() output and it works fine. Anyway, for those using VB, this is potentially hazardous. Knowing that the underl

Re: [SQL] max() unexpected type conversion

2005-11-21 Thread Tom Lane
"=?iso-8859-1?Q?H=E9lder_M._Vieira?=" <[EMAIL PROTECTED]> 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* fun