On Nov 11, 2007, at 18:46 , Patric Bechtel wrote:
> Given a table bla(a bigint,b text)
>
> select * from bla where a like '8%'
>
> works in <=8.2, but not on 8.3
>
> Same happens with date columns, too.
The server is now more strict and has fewer implicit type casts in
8.3, so this is working as intended. If you want to treat a bigint or
a date as a string, explicitly cast it.
Michael Glaesemann
grzm seespotcode net