ARRAY[] with \'s is broken? - Mailing list pgsql-hackers

From Rod Taylor
Subject ARRAY[] with \'s is broken?
Date
Msg-id 1116347181.696.148.camel@home
Whole thread Raw
Responses Re: ARRAY[] with \'s is broken?  (Andrew Dunstan <andrew@dunslane.net>)
List 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,
compiledby 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)




-- 



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: SQL99 hierarchical queries stalled
Next
From: Joe Conway
Date:
Subject: Re: alternate regression dbs?