> > 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
>
> This shows that the row exists in the table:
>
> emystery=> select aid,useragent from useragent where useragent like '%ntserver-ps%';
> aid|useragent
> ---+
On 30/06/2003 12:25 Shane Wright wrote:
Hi
This is really driving me silly - I can't work it out, can anyone see
what I'm doing thats stupid and causing this not to match?
This shows that the row exists in the table:
emystery=> select aid,useragent from useragent where useragent like
'%ntserver-p
you might want to try escaping the simple slashes aswell... and you have
to double the number of backslashes
learning=> SELECT * FROM test where x like '';
x
---
\
(1 row)
*tadaaa*
cheers,
alex
Shane Wright wrote:
Hi
This is really driving me silly - I can't work it out, can anyone
Should have said - I'm using postgreSQL 7.3.3 on Gentoo Linux. The problem occurs
both through psql and through PHP4.3.3.
Cheers
Shane
On Monday 30 Jun 2003 12:25 pm, Shane Wright wrote:
> Hi
>
> This is really driving me silly - I can't work it out, can anyone see what
> I'm doing thats stu
Hi
This is really driving me silly - I can't work it out, can anyone see what I'm doing
thats stupid and causing this not to match?
This shows that the row exists in the table:
emystery=> select aid,useragent from useragent where useragent like '%ntserver-ps%';
aid|
