On Fri, 26 Oct 2001, Andy Hallam wrote:
> 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.
Actually, it's probably the backend since I'm pretty sure you get the
same thing in psql. IIRC, the \ is treated as an escape character to
escape what follows (like a ' or for providing octal values).
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2001-10-29 18:15:58|
|Subject: Re: Bug #500: Cannot create View and Problems With the UNION clause |
|Previous:||From: Stephan Szabo||Date: 2001-10-29 17:53:57|
|Subject: Re: reference to inherited column in parent|