From: | "alex b(dot)" <mailinglists1(at)gmx(dot)de> |
---|---|
To: | Shane Wright <me(at)shanewright(dot)co(dot)uk> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: weird quote bug |
Date: | 2003-06-30 11:50:52 |
Message-ID: | 3F00241C.7080508@gmx.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 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 | useragent
> -----------+---------------------------------------------------------------------------------------------------------
> 875741007 | Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; file://\\ntserver-ps\publicsw\nt\ie6\ins\active.ins)
> (1 row)
>
>
> this tries to select it (note that I've escaped the backslashes):
>
>
> emystery=> select * from useragent where useragent ilike 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; file://\\\\ntserver-ps\\publicsw\\nt\\ie6\\ins\\active.ins)';
> aid | useragent | date_added | data_browser | data_version | data_os
> -----+-----------+------------+--------------+--------------+---------
> (0 rows)
>
>
> no match! This one encodes the backslashes (\xxx octal for ASCII value) in a different way:
>
>
> emystery=> select * from useragent where useragent ilike 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; file://\134\134ntserver-ps\134publicsw\134nt\134ie6\134ins\134active.ins)';
> aid | useragent | date_added | data_browser | data_version | data_os
> -----+-----------+------------+--------------+--------------+---------
> (0 rows)
>
>
> again no match! And to show that the above queries were correct:
>
>
> emystery=> select 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; file://\\\\ntserver-ps\\publicsw\\nt\\ie6\\ins\\active.ins)';
> ?column?
> ---------------------------------------------------------------------------------------------------------
> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; file://\\ntserver-ps\publicsw\nt\ie6\ins\active.ins)
> (1 row)
>
> emystery=> select 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; file://\134\134ntserver-ps\134publicsw\134nt\134ie6\134ins\134active.ins)';
> ?column?
> ---------------------------------------------------------------------------------------------------------
> Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; file://\\ntserver-ps\publicsw\nt\ie6\ins\active.ins)
> (1 row)
>
>
>
> 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!
>
> Thanks
>
> Shane
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2003-06-30 11:53:17 | Re: weird quote bug |
Previous Message | Shane Wright | 2003-06-30 11:36:11 | Re: weird quote bug |