On Thu, Aug 27, 2009 at 11:39 AM, Ruzsinszky
> 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'
In response to
pgsql-novice by date
|Next:||From: Steve T||Date: 2009-08-27 15:27:18|
|Subject: Speeding up 'bulk' delete (and/or seeing what is going on whilethe delete is being processed)|
|Previous:||From: Lennin Caro||Date: 2009-08-27 14:39:38|
|Subject: Re: compilation error|