Re: ARRAY[] with \'s is broken?

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?

> andrew=# select ARRAY['\\a'] as f1, ARRAY['\a']as f2 , ARRAY['\\\a'] as f2; 
> 
>    f1    | f2  |   f2    
> 
>  --------+-----+---------
> 
>  {"\\a"} | {a} | {"\\a"}
> 
> It might be mildly confusing because '\a' == 'a'

> cheers
> 
> andrew
> 
> 
> 
> Rod Taylor wrote:
> 
> >Can anyone explain what's going on with the slashes?
> >
> >ssdb=# select version();
> >                                  version
> >---------------------------------------------------------------------------
> > PostgreSQL 8.0.1 on sparc-sun-solaris2.9, compiled by GCC gcc (GCC)
> >3.4.2
> >(1 row)
> >
> >ssdb=# select ARRAY['\\a'];
> >  array
> >---------
> > {"\\a"}
> >(1 row)
> >
> >ssdb=# select ARRAY['\a'];
> > array
> >-------
> > {a}
> >(1 row)
> >
> >ssdb=# select ARRAY['\\\a'];
> >  array
> >---------
> > {"\\a"}
> >(1 row)
> >
> >
> >
> >
> >  
> >
> 
--