| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Andy Hallam <ahm(at)exel(dot)co(dot)uk> |
| Cc: | <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: Select with backslash '\' character |
| Date: | 2001-10-29 17:56:33 |
| Message-ID: | 20011029095411.X9662-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-10-29 18:15:58 | Re: Bug #500: Cannot create View and Problems With the UNION clause |
| Previous Message | Stephan Szabo | 2001-10-29 17:53:57 | Re: reference to inherited column in parent |