ARRAY[] with \'s is broken?

From: Rod Taylor <pg(at)rbt(dot)ca>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: ARRAY[] with \'s is broken?
Date: 2005-05-17 16:26:21
Message-ID: 1116347181.696.148.camel@home
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Can anyone explain what's going on with the slashes?

ssdb=# select version();
version
---------------------------------------------------------------------------
PostgreSQL 8.0.1 on sparc-sun-solaris2.9, compiled by GCC gcc (GCC)
3.4.2
(1 row)

ssdb=# select ARRAY['\\a'];
array
---------
{"\\a"}
(1 row)

ssdb=# select ARRAY['\a'];
array
-------
{a}
(1 row)

ssdb=# select ARRAY['\\\a'];
array
---------
{"\\a"}
(1 row)

--

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2005-05-17 17:01:32 Re: alternate regression dbs?
Previous Message Bruce Momjian 2005-05-17 15:34:17 Re: SQL99 hierarchical queries stalled