Postgres Pro
Downloads
Home   >   mailing lists

Select with backslash '\' character - Mailing list pgsql-bugs

From Andy Hallam
Subject Select with backslash '\' character
Date
Msg-id 9rc03b$16df$1@news.tht.net
Whole thread Raw
Responses Re: Select with backslash '\' character  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Select with backslash '\' character  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-bugs
Tree view 
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@exel.co.uk

pgsql-bugs by date:

Previous
From: "Rumi Szabolcs"
Date:
Subject: reference to inherited column in parent
Next
From: Bobo
Date:
Subject: writing '\' in an array