Skip site navigation (1) Skip section navigation (2)

Re: Select with backslash '\' character

From: "Andy Hallam" <ahm(at)exel(dot)co(dot)uk>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Select with backslash '\' character
Date: 2001-10-29 09:51:03
Message-ID: 9rj8sl$cqa$1@news.tht.net (view raw or flat)
Thread:
Lists: pgsql-bugs
Just to clarify.

---
The below SELECT SQL was ran from the command line:

mydb=# SELECT a FROM b WHERE c = 'WORKGROUP\me'
Result = Zero rows returned.

mydb=# SELECT a FROM b WHERE c = 'WORKGROUP\\me'
Result = One row returned.

---
And from my C app.

strcpy(strID, "WORKGROUP\\me");
Result = Zero rows returned.

strcpy(strID, "WORKGROUP\\\\me");
Result = One row returned.


"Andy Hallam" <ahm(at)exel(dot)co(dot)uk> wrote in message
news:9rc03b$16df$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> PostgreSQL - 7.1.3  (installed on Linux 2.4.2-2)
> PSQLODBC.DLL - 07.01.0007
> Visual C++ - 6.0
>
> SELECT a FROM b WHERE c = 'WORKGROUP\me'
>
> Does not return any rows.
>
> SELECT a FROM b WHERE c = 'WORKGROUP\\me'
>
> Returns required rows.
>
> Result = PostgreSQL ODBC driver cannot handle backslash character - have
to
> escape it myself.
>
> Can someone confirm this to be a bug please.
>
> Thanks.
>
> Andy
> ahm(at)exel(dot)co(dot)uk
>
>
>



In response to

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2001-10-29 10:29:06
Subject: Bug #500: Cannot create View and Problems With the UNION clause
Previous:From: BoboDate: 2001-10-29 05:17:06
Subject: writing '\' in an array

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group