> > How the heck do you store a single backslash in an text array?
>
> ... array_out doubles the backslashes again, though.
That explains how I got confused.
> regression=# select ARRAY['\\a'];
> array
> ---------
> {"\\a"}
> (1 row)
>
> regression=# select (ARRAY['\\a'])[1];
> array
> -------
> \a
> (1 row)
>
> regards, tom lane
>
--