> > 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
>
--
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
