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

Rod Taylor wrote:

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

Well, in v 8.0 I use dollar quoting :-)

select ARRAY[$\$];

But as Tom says the text output  function will double it.

cheers

andrew