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

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ARRAY[] with \'s is broken?
Date: 2005-05-17 17:49:36
Message-ID: 428A2EB0.6040705@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2005-05-17 18:20:11 Re: Learning curves and such (was Re: pgFoundry)
Previous Message Rod Taylor 2005-05-17 17:46:11 Re: ARRAY[] with \'s is broken?