label() is quoting isnull because isnull is listed as a reserved
word. literal_column(isnull) is not, because literal_column does
exactly what you say.
So id try first not using the word isnull for the label. After
that, its possible that SQlite isnt going to let you allow ordering by
1 - changing isnull to foo worked. thanks!
2 - i tried adding text('nulls last') in the order_by(...), but got an
error from sqlite. i don't suppose there's something clever in
sqlalchemy that does this in a portable way is there?
3 - what do you use as a reference for SQL? do you have the
the case solution works too, which is what i'll go with. thanks.
--~--~-~--~~~---~--~~
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