Case insensitive "order by" clause in tolog?

[F. Andy Seidl]

Is it possible to perform a case-insensitive sorting by topic name in
a tolog query?

[Lars Marius Garshol]

* F. Andy Seidl

>
> Is it possible to perform a case-insensitive sorting by topic name in
> a tolog query?

Yes, it is. You need to either store a case-insensitive sort key on the topic, or do the transform as part of the query. The translate predicate in the string module is perfect for this.

Looking at the documentation I see that the documentation for this particular predicate is commented out, with the note "needs more work". :-/

I'll fix that ASAP.

--Lars M.
http://www.garshol.priv.no/tmphoto/
http://www.garshol.priv.no/blog/

[F. Andy Seidl]

Thanks, Lars. A translate predicate was what I had gone looking
for. ;-)

Now that I know it exists, I'll take a shot at figuring it out from
the source code.

On Nov 30, 1:59 pm, Lars Marius Garshol <lar...@garshol.priv.no>
wrote:

[F. Andy Seidl]

Got it:

import "http://psi.ontopia.net/tolog/string/" as str
select $TOPIC, $LCNAME from
instance-of($TOPIC, @T35604),
topic-name($TOPIC, $TNAME),
value($TNAME, $TNAMESTR),
str:translate($LCNAME, $TNAMESTR, "ABCDEFGHIJKLMNOPQRSTUVWXYZ",
"abcdefghijklmnopqrstuvwxyz", "")
order by $LCNAME?

Thanks for the pointer.
-- fas

On Nov 30, 2:39 pm, "F. Andy Seidl" <fase...@myst-technology.com>
wrote:

> > --Lars M.http://www.garshol.priv.no/tmphoto/http://www.garshol.priv.no/blog/- Hide quoted text -
>
> - Show quoted text -

[Lars Marius Garshol]

* F. Andy Seidl
>
> Got it: [...]

That's it, yes. Now finally managed to document the predicate as well:
http://code.google.com/p/ontopia/source/detail?r=705