Re: ARRAY[] with \'s is broken? - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: ARRAY[] with \'s is broken?
Date
Msg-id 1116351971.696.195.camel@home
Whole thread Raw
In response to Re: ARRAY[] with \'s is broken?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> > 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
> 
-- 



pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Learning curves and such (was Re: pgFoundry)
Next
From: Andrew Dunstan
Date:
Subject: Re: ARRAY[] with \'s is broken?