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
Thank you for your prompt reply
2007/5/5, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> "Oliveiros Cristina" <oliveiros(dot)cristina(at)gmail(dot)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
> > 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
In response to
pgsql-novice by date
|Next:||From: Jim Nasby||Date: 2007-05-06 15:23:24|
|Subject: Re: including limited lines depending on input parameter|
|Previous:||From: Tom Lane||Date: 2007-05-06 00:34:42|
|Subject: Re: Importing a CSV file to a table on Postgres |