Rod Taylor <pg@rbt.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