* Tom Lane <[EMAIL PROTECTED]> [2002-04-21 11:12 -0400]: > Gerhard =?iso-8859-15?Q?H=E4ring?= <[EMAIL PROTECTED]> 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 Thanks. The bug was elsewhere: in the client library I use. I fixed this in the meantime. The CVS version of pyPgSQL now supports ARRAYs and even multidimensional ARRAYs.
Gerhard -- mail: gerhard <at> bigfoot <dot> de registered Linux user #64239 web: http://www.cs.fhm.edu/~ifw00065/ OpenPGP public key id AD24C930 public key fingerprint: 3FCC 8700 3012 0A9E B0C9 3667 814B 9CAA AD24 C930 reduce(lambda x,y:x+y,map(lambda x:chr(ord(x)^42),tuple('zS^BED\nX_FOY\x0b'))) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster