Re: EOF & DISTINCT/ORDER BY problem - need help...

"Arturo Perez" <[email protected]> Thu, 27 Jan 2005 12:05:13 -0500

Newsgroups	gmane.comp.web.webobjects.devel,gmane.comp.web.webobjects.eof
Message-ID	<[email protected]>

Simeon Johnston wrote:

> This sql was generated by EOF -
> 
> SELECT DISTINCT t0.A_BOOLEAN, t0.A_VARCHAR, t0.THE_PK, t0.LABEL, t0.TYPE 
> FROM THE_STUPID_TABLE t0 WHERE (t0.A_BOOLEAN = true AND t0.TYPE = 2) 
> ORDER BY UPPER(t0.LABEL) ASC
> 

I'm wondering how you got that UPPER in there?

> Using WO 5.2.3 w/ PostgreSQL 7.4.6 & jdbc driver w/ Hexdreams plugin.

The project wonder plugin will generate more pgSQL-compliant SQL.  That 
being said, I wonder if putting a derived column of UPPER(LABEL) will 
help you out?

-arturo