Manlio Perillo wrote: > -----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?
couple of years old at this point...goes back to 0.4 at least > >> 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. > > -- 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.