Ivan Sergio Borgonovo wrote:
It'd be nice to have a wrapper that let you write prepared statements
this way:
"select a.id, b.name from a join b on a.id=b.id where
a.status=$variable1 and b.id>$variable2 etc... but that's a pretty
good change to any language parser.
Python already supports something like that. See PEP 249
(http://www.python.org/dev/peps/pep-0249/), under Module Interface, the
description of the paramstyle parameter. Psycopg2 supports both the
"format" (C printf) and "pyformat" styles. See the last section on this
page for an example using the pyformat style:
http://www.devx.com/opensource/Article/29071/0/page/3.
Joe
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
