On Jun 9, 2008, at 12:56 PM, Christoph Zwerschke wrote:
>
> Michael Bayer wrote:
>> I tend to use a CASE statement for this: CASE WHEN x IS NULL THEN 0
>> ELSE x . We have case() construct for that.
>
> Yes, but that still leaves me with having to code "infinity" some way.
>
>> For your version, use func.coalesce(start,
>> literal_column("timestamp '-
>> infinity'")) .
>
> Thank you. literal_column was exactly what I was looking for.
>
> Though I still would like to have "nulls first/last" as well, this
> construct is also useful when checking date ranges with "between".
yeah we have the ticket, sooner or later unless someone patches.... :)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
