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