Re: weird quote bug

From: Shane Wright <me(at)shanewright(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: weird quote bug
Date: 2003-06-30 12:06:17
Message-ID: 200306301306.17828.me@shanewright.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-06-30 12:24:15 Re: tweaking PG and "machine health".
Previous Message Henrik Steffen 2003-06-30 12:02:58 Cannot create unique index