Re: [HACKERS] ARRAY[] with \'s is broken?

[Andrew Dunstan]

I don't see anything broken. V 7.4.8 shows the same:
andrew=# select ARRAY['\\a'] as f1, ARRAY['\a']as f2 , ARRAY['\\\a'] as f2; 

  f1    | f2  |   f2    

--------+-----+---------
{"\\a"} | {a} | {"\\a"}
It might be mildly confusing because '\a' == 'a'
cheers
andrew

Rod Taylor wrote:
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)

 

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend