| From: | Greg Stark <gsstark(at)mit(dot)edu> |
|---|---|
| To: | Ruzsinszky Attila <ruzsinszky(dot)attila(at)gmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Simple like filter |
| Date: | 2009-08-27 15:17:04 |
| Message-ID: | 407d949e0908270817n118fe0eck91860d3cab30e1f7@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Thu, Aug 27, 2009 at 11:39 AM, Ruzsinszky
Attila<ruzsinszky(dot)attila(at)gmail(dot)com> wrote:
> 11111_123456 (varchar(20))
>
> I would like a where like SQL command.
> I tried this: like E'11\_%' -> wrong!
> like E'11\_______' -> good (with 7 piece of _ characters!)
You either want E'11\\_%' or you want '11\_%' with
standard_conforming_strings enabled. If you use E'11\_%' the backslash
is getting eaten before the like comparison even starts and the string
you're comparing with is just 11_% with _ used as a meta character.
You can also do s LIKE '%Q_%' ESCAPE 'Q'
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve T | 2009-08-27 15:27:18 | Speeding up 'bulk' delete (and/or seeing what is going on while the delete is being processed) |
| Previous Message | Lennin Caro | 2009-08-27 14:39:38 | Re: compilation error |