From: | "David Johnston" <polobo(at)yahoo(dot)com> |
---|---|
To: | "'Andy Chambers'" <achambers(at)mcna(dot)net>, "'pgsql'" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Weird "LIKE" behaviour |
Date: | 2012-07-06 20:26:51 |
Message-ID: | 002d01cd5bb5$af6fa470$0e4eed50$@yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> -----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.
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Andy Chambers | 2012-07-06 20:34:05 | Re: Weird "LIKE" behaviour |
Previous Message | Andy Chambers | 2012-07-06 20:16:33 | Weird "LIKE" behaviour |