Gerhard =?iso-8859-15?Q?H=E4ring?= <haering_linux(at)gmx(dot)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