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