Re: Escaping of special characters in ARRAYs is broken - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Escaping of special characters in ARRAYs is broken
Date
Msg-id 5818.1019401962@sss.pgh.pa.us
Whole thread Raw
In response to Escaping of special characters in ARRAYs is broken  (Gerhard Häring <haering_linux@gmx.de>)
Responses Re: Escaping of special characters in ARRAYs is broken  (Gerhard Häring <haering_linux@gmx.de>)
List pgsql-bugs
Gerhard Häring <haering_linux@gmx.de> writes:
> You can see the inconsistency yourself when you try to insert a special
> character like \005 into a varchar array. IMO This should work with inserting
> '{"\\005"}', but this just inserts the three letters 005.

This is not a bug; you didn't use enough backslashes.  See the example
at the bottom of this page:
http://candle.pha.pa.us/main/writings/pgsql/sgml/arrays.html
        regards, tom lane


pgsql-bugs by date:

Previous
From: Gerhard Häring
Date:
Subject: Escaping of special characters in ARRAYs is broken
Next
From: Michael Loftis
Date:
Subject: Re: PostgreSql Installation