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