Forum OpenACS Q&A: Response to Problem getting bootstrapped

Collapse
Posted by Ola Hansson on
Hmm..

I thought I was doing well rewriting the almost twenty queries I've found so far (most of witch were in the intranet module). It turns out that I'm unsure of what to do with some "order by" clauses containing "upper()" functions that PG 7.1 can't seem to handle..

Usually I can't put the "upper()" stuff in the select part of the query because I don't feel like displaying an upper-case name for example. It doesn't seem like a good idea to drop the functions either.

Suggestions?