Hello, Tom,
Thank you for your email
Yes, what you say makes all sense, but I am not 100% sure if the program looks exactly as I wrote, I did it by memory. Anyway, I'll check it out tomorrow at office with my colleague and if more doubts arise, I'll get back to list.
Thank you for your prompt reply
Best,
Oliveiros
2007/5/5, Tom Lane < tgl@sss.pgh.pa.us>: "Oliveiros Cristina" <oliveiros.cristina@gmail.com> writes:
> Suppose I have a row on this table e.g.
> 120120 ....... www.record.pt\
> If , on PgAdmin, I query
> SELECT IDSite
> FROM t_sites
> WHERE "tName"='www.record.pt\\\\'
> I get nothing, as expected, because the string has two final backslashes,
> not one, as the record on table.
> But if I try to do it on C# it returns me the 120120. (??) It shouldn't
> return nothing as well.
> The program is as follows :
> strSite = "www.record.pt\\\\"
I don't know C# well, but if it's at all like C then the string that
is represented by this literal has only two backslashes, and when it
gets to the backend that reduces to one backslash, so it matches.
regards, tom lane