-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Michael Bayer ha scritto: > Manlio Perillo wrote: > [...] >>>> OK you mean SQL expression during compilation. This is ticket #1534 >>>> which is not yet implemented. >> >> After some tests I got something that works >> http://paste.pocoo.org/show/173099/ >> > [...] > > errr, you can put SQL expressions into insert.values(), but not in the > params sent to execute() (that was discontinued after 0.4).
I have never used the values method. Is this a recent feature? > the example > you have is actually executing the sql.select() statement beforehand since > thats what "scalar()" does. > > you're looking for > > query = test.insert().values(text=sql.func.to_tsvector(u'some text')) > engine.execute(query) > Thanks. Manlio -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAktolCUACgkQscQJ24LbaURINgCglj+N2JKqkWit1/DFCEBff2Kd 7fsAn0F8Y5mUCYyqWSxydosxk36RzsGZ =VHYH -----END PGP SIGNATURE----- -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.