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