Skip site navigation (1) Skip section navigation (2)

Re: Escaping of special characters in ARRAYs is broken

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Gerhard Häring <haering_linux(at)gmx(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Escaping of special characters in ARRAYs is broken
Date: 2002-04-21 15:12:42
Message-ID: 5818.1019401962@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
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

In response to

Responses

pgsql-bugs by date

Next:From: Michael LoftisDate: 2002-04-21 17:56:40
Subject: Re: PostgreSql Installation
Previous:From: Gerhard HäringDate: 2002-04-21 09:38:15
Subject: Escaping of special characters in ARRAYs is broken

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group