On Fri, Jul 6, 2012 at 4:26 PM, David Johnston <pol...@yahoo.com> wrote: >> -----Original Message----- >> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- >> ow...@postgresql.org] On Behalf Of Andy Chambers >> Sent: Friday, July 06, 2012 4:17 PM >> To: pgsql >> Subject: [GENERAL] Weird "LIKE" behaviour >> >> Below are two queries that should be pretty much the same but with the >> first one, I'm trying to boil it down to a minimal test-case so I don't > have to >> export the table definition of dcm.providers. The first one returns > nothing >> but at least executes the query. >> >> => create table foo ( foo text ); >> => select * from foo where foo like 'FOO%\' >> >> The second one fails to execute the query... >> >> => select * from dcm.providers where lname like 'FOO%\' >> ERROR: LIKE pattern must not end with escape character >> >> Our server is 9.1.4 and can reproduce this behaviour with either 8.4 or > 9.1 >> clients. >> > > The only part of the table "dcm.providers" that should matter is the data > type of the "lname" column - which you have not provided.
I thought it might be due to the datatype too. Originally it was character varying (30) but I "alter table'd" it to text to see if that was the problem. Perhaps the fact that it was originally a varchar makes the difference. I'll check that now. Thanks, Andy -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
