From: | Andy Chambers <achambers(at)mcna(dot)net> |
---|---|
To: | pgsql <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Weird "LIKE" behaviour |
Date: | 2012-07-06 20:34:05 |
Message-ID: | CAAfW55q1zT98S-YbjC7cc6d3Z0W-ixo_BFJmkF6=ON-oPX_mUw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Jul 6, 2012 at 4:26 PM, David Johnston <polobo(at)yahoo(dot)com> wrote:
>> -----Original Message-----
>> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
>> owner(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | David Johnston | 2012-07-06 20:50:21 | Re: Weird "LIKE" behaviour |
Previous Message | David Johnston | 2012-07-06 20:26:51 | Re: Weird "LIKE" behaviour |