Re: Using NULLS FIRST/LAST on sort orderings
Re: Using NULLS FIRST/LAST on sort orderings
- Subject: Re: Using NULLS FIRST/LAST on sort orderings
- From: Lachlan Deck <email@hidden>
- Date: Wed, 7 Jan 2009 13:36:45 +1100
On 07/01/2009, at 12:59 PM, Miguel Arroz wrote:
On 2009/01/06, at 23:56, Lachlan Deck wrote:
On 07/01/2009, at 4:29 AM, Miguel Arroz wrote:
Nop. Must be in the DB, it's too many data to handle in memory
(the table that shows it is paged).
This is not achievable apart from in-memory. SQL does not allow for
this. Period.
Yes it does! :) It depends on the DB you are using (and the version).
Check, for instance, <http://www.postgresql.org/docs/current/interactive/queries-order.html
>. You can append NULLS FIRST or NULLS LAST to each ORDER BY
expression.
Cool. But that's rare.
It would rock to have a way to use this on WO. I've been wondering
how to add this to Wonder
Have a look at some of the existing custom erx/houdah sort orderings
and subclass.
with regards,
--
Lachlan Deck
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden