Rod Taylor <pg(at)rbt(dot)ca> writes:
> On Tue, 2005-05-17 at 13:18 -0400, Andrew Dunstan wrote:
>> I don't see anything broken. V 7.4.8 shows the same:
> How the heck do you store a single backslash in an text array?
You just did. array_out doubles the backslashes again, though.
regression=# select ARRAY['\\a'];
array
---------
{"\\a"}
(1 row)
regression=# select (ARRAY['\\a'])[1];
array
-------
\a
(1 row)
regards, tom lane