I also think two underscores make a literal underscore. Same with %.
> On Sat, 28 Jul 2001, Roy Souther wrote:
>
> > In PG the _ is a wildcard that means any singal char. I need to do a search
> > for the actual _ char and not get back thousands of wrong matches. Is there
> > and escape char that I could use? This needs to work with PG 7.0.3 & 7.1.2.
>
> \\_ should work for a literal escape.
> At least on current sources you can do something like:
> like 'blah!_%' escape '!'
> where ! becomes the escape character for the string.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026
