Re: weird quote bug - Mailing list pgsql-general

From Shane Wright
Subject Re: weird quote bug
Date
Msg-id 200306301306.17828.me@shanewright.co.uk
Whole thread Raw
In response to Re: weird quote bug  (Paul Thomas <paul@tmsl.demon.co.uk>)
List pgsql-general
> > They are identical!  I can't work out whats going on!  Please, if anyone
> > can see what's wrong it'll stop me careering into my early grave!
>
> I've never tried this but the docs for LIKE (secfion 6.6.1 in the 7.3
> docs) say that to match a literal \ you need to type \\\\. An alternative
> might be to try adding an ESCAPE '' clause at the end (also in the same
> doc section).

Ah.  I had soooo read that bit of the manual - must have missed it.  Phew it works now!

Thanks (and thanks to the others who answered my question!)

Cheers

Shane


pgsql-general by date:

Previous
From: "Henrik Steffen"
Date:
Subject: Cannot create unique index
Next
From: "scott.marlowe"
Date:
Subject: Re: tweaking PG and "machine health".