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

From Hélder M. Vieira
Subject Re: max() unexpected type conversion
Date
Msg-id 002a01c5ef05$da3bbc30$6200a8c0@hmv02
Whole thread Raw
In response to max() unexpected type conversion  (Hélder M. Vieira <hmv@mail.telepac.pt>)
List pgsql-sql
> 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
underlying data is of type 'varchar', one has to be always very cautious
about the 'text' conversion, otherwise all readings after the first will
return null instead of valid data.



Helder M. Vieira




pgsql-sql by date:

Previous
From: george young
Date:
Subject: Re: tid_le comparison for tuple id (ctid) values?
Next
From: Samer Abukhait
Date:
Subject: Re: Please help to wite the constraint.