-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 richard reitmeyer ha scritto: > Hello, all. > > I'm trying to use compound fields with in_ to achieve something like > this: > > update foo set svrid = NULL, asof=NULL > where (svrid,asof) > in (select svrid, asof from foo except select svrid, > asof from bar); >
If you are using PostgreSQL, you can use the ROW constructor. Regards Manlio -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkufw6wACgkQscQJ24LbaUTiuQCfUhN26bZA7FTzWZK8wWYl7L73 q8MAn0vu60420NU9DwPlGQCdl2EuSNAA =fEMJ -----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.