R: strange characters

From: "Manera, Villiam" <vmanera(at)manord(dot)com>
To: <psycopg(at)postgresql(dot)org>
Cc: "Adrian Klaver" <adrian(dot)klaver(at)gmail(dot)com>
Subject: R: strange characters
Date: 2011-01-10 15:01:29
Message-ID: 4B0D10F422F80F479C5372363DE21FB1026A2E4D@mail2.manord.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Adrian wrote:
>If you are referring to the 'E' it is not strange. That is the new
Postgres
>escape identifier. The backslash escape is being phased out.

Ok, but the execute cursor will abort:
>>> cur.execute("select * from anamat.collezioni where
coll='%(coll)s'",{'coll':'1'});
Traceback (most recent call last):
File "<interactive input>", line 1, in <module>
ProgrammingError: syntax error at or near "1"
LINE 1: select * from anamat.collezioni where coll='E'1''

Villiam

In response to

Responses

Browse psycopg by date

  From Date Subject
Next Message Adrian Klaver 2011-01-10 15:24:33 Re: R: strange characters
Previous Message Adrian Klaver 2011-01-10 15:00:08 Re: strange characters