for now yes, I've not heard of IS DISTINCT FROM before.
On Oct 14, 2011, at 6:25 PM, Jon Nelson wrote:
On Fri, Oct 14, 2011 at 4:45 PM, Jon Nelson jnel...@jamponi.net wrote:
What is the SA equivalent of:
UPDATE foo SET bar=some_function(baz) WHERE bar IS DISTINCT FROM
some_function(baz)
I get this far (assuming 't' is a Table instance):
t.update().values(t.c.bar=sa.func.some_function(t.c.baz).where( ...
what do I put here )
IS DISTINCT FROM (and IS NOT DISTINCT FROM) are supported in firebird
and postgresql, and possibly others.
Is using 'op' the right way?
c = sa.func.some_function(t.c.baz)
t.update().values(t.c.bar=c).where(t.c.bar.op(IS DISTINCT FROM)(c))
--
Jon
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@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 sqlalchemy@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.