On Fri, Feb 17, 2012 at 2:45 AM, Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> wrote: > Of course, the best fix would be to change your queries. It's quite sloppy > to rely on "integer LIKE text" without an explicit cast in the query.
Why? I understand why it's a bad idea to rely on integer = text doing anything sane - is that text equality or numeric equality? And in theory the same issue could exist here if there were another meaning for LIKE. But there isn't. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers