Re: psycopg, datetime timestamps and intervals

Il giorno lun, 21/04/2008 alle 10.46 -0700, Tim Roberts ha scritto:
> Karsten Hilbert wrote:
> > On Sat, Apr 19, 2008 at 10:45:11AM +0200, Federico Di Gregorio wrote:
> >
> >   
> >> This is wrong. psycopg just does variable substitution.
> >>     
> > Unfortunately. Any chance this will change ?
> >   
> 
> I hope not.  Parameterized queries weren't supported in the Postgres 
> protocol until version 3, which wasn't introduced until Postgres 7.4.  I 
> still support clients that use older versions.  Plus, when you use the 
> parameterized API, you can't do multiple SQL statements per call.
> 
> Those are all solvable problems, but we need to be conscious of the 
> consequences when we break backwards compatibility.

If we implement parameterized queries the old code path won't go away.
The new query type will require an explicit variable to be se on the
connection or, in case of repeated prepare queries, an explicit method
call.

-- 
Federico Di Gregorio                         http://people.initd.org/fog
Debian GNU/Linux Developer                                [email protected]
INIT.D Developer                                           fog-NGVKUo/i/[email protected]
 Il panda ha l'apparato digerente di un carnivoro (e.g., di un orso).
  Il panda ha scelto di cibarsi esclusivamente di germogli di bambù.
  Quindi, il panda è l'unico animale vegano del pianeta. Il panda
  merita di estinguersi.                       -- Maria, Alice, Federico

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/[email protected]
http://lists.initd.org/mailman/listinfo/psycopg

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQBIDPolvcCgrgZGjesRApybAJ9nrKrKhs35sDBwbD74SWl8xp5V3gCfa4g2
JiE0YGteVKGTfDJQ33yU2nQ=
=2BZF
-----END PGP SIGNATURE-----