On 02/11/2013 06:59 PM, Scott Marlowe wrote:
> Wait I think it was 8.2 wasn't it?
http://www.postgresql.org/docs/8.3/interactive/release-8-3.html
E.24.2.1. General
Non-character data types are no longer automatically cast to TEXT
(Peter, Tom)
Previously, if a non-character value was supplied to an operator or
function that requires text input, it was automatically cast to text,
for most (though not all) built-in data types. This no longer happens:
an explicit cast to text is now required for all non-character-string
types. For example, these expressions formerly worked:
>
> On Mon, Feb 11, 2013 at 7:58 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Scott Marlowe <scott.marlowe@gmail.com> writes:
>>> The change from 8.0 to 8.1 that removed implicit casts broke a LOT of
>>> poorly written software.
>>
>> That was 8.3, not 8.1.
>>
>> regards, tom lane
>
>
>
--
Adrian Klaver
adrian.klaver@gmail.com