[redland-dev] order by on dates

[Danny Ayers]

On 6/7/05, Dave Beckett <dave.beckett at bristol.ac.uk> wrote:

> I guess you'll be happy to know that I added an initial sorting
> implementation in the query engine CVS this morning.  

Bravo!

Sorting is
> performed on all results in memory (so don't try that with huge results)
> and it's with stringy compares so integer 10 collates less
> than integer 2 since "10" < "2", i.e. like RDQL.  Fixing that is
> piles of detail.   So date sorting might work if you stick to
> a normalised form such as without timezones.

Great stuff, I can definitely use this.

I did discover a workaround - xsl:sort on the results - but as the
main aim of the app is to show off SPARQL, it's not exactly elegant.
Ideally I would like to sort on the MySQL models, in fact I took a
brief look at rdf_storage_mysql.c, wondering if there was an easy way
to slip in an order by there. Waaa! Scary code. In-memory sorting will
do just fine for now (although I might still badger* Morten).

Cheers,
Danny. 

* http://www.badgerbadgerbadger.com/

-- 

http://dannyayers.com