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

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)
>
>
>
>
>  
>