Simon King wrote:
I don't know if this is valid SQL, but MySQL seems to accept
it... I'd like to write a query that looks like:
SELECT s.result LIKE 'Pass%' AS pass
...
Which would return 1 or 0 for each row depending on whether
the result column begins with Pass.
Another way I tried to do this was to use the SQL:
SELECT IF(s.result LIKE 'Pass%', 'Pass', 'Fail') AS pass
...
because that would be a function rather than a boolean expression, and
functions can be labelled. I knew I couldn't call 'sa.func.if', but I
thought it would be nice if you could use sa.func.if_ - the
_FunctionGateway object could strip the trailing underscore from the
name. It took me a while to realise I could use sa.func.IF, but the
capital letters look ugly :-). Alternatively, _FunctionGateway could be
given a __call__ method which would take the name as a parameter, so you
could use 'sa.func("if")'.
Just an idea.
Simon
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---