Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Postgresql NULLS FIRST Order by(How to indicate NULLS FIRST in order by expression?)
Postgresql NULLS FIRST Order by [message #842503] Thu, 12 April 2012 11:02 Go to next message
Miguel Goncalves is currently offline Miguel GoncalvesFriend
Messages: 3
Registered: April 2012
Location: Portugal
Junior Member
Hi,

How to indicate NULLS FIRST in order by expression?
I'm using PostgreSQL 9.1, EclipseLink 2.3.2.

Thanks,

Miguel Goncalves
Re: Postgresql NULLS FIRST Order by [message #846657 is a reply to message #842503] Mon, 16 April 2012 14:28 Go to previous messageGo to next message
James Sutherland is currently offline James SutherlandFriend
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
Senior Member

This will be supported in EclipseLink 2.4 (lastest nightly build).

In previous versions you can use a native SQL query.


James : Wiki : Book : Blog : Twitter
Re: Postgresql NULLS FIRST Order by [message #899652 is a reply to message #846657] Wed, 01 August 2012 16:49 Go to previous messageGo to next message
Jorge Bautista is currently offline Jorge BautistaFriend
Messages: 1
Registered: August 2012
Junior Member
Hi,

I'm using EclipseLink 2.4.0 and the statement NULLS LAST still derives in a:

"...unexpected token [NULLS]"

Does any body has some information about this?

Thanks!
Re: Postgresql NULLS FIRST Order by [message #899660 is a reply to message #899652] Wed, 01 August 2012 17:21 Go to previous message
James Sutherland is currently offline James SutherlandFriend
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
Senior Member

Please include your full JPQL query and the full exception.


James : Wiki : Book : Blog : Twitter
Previous Topic:Very strange "primary key [null]" validation exception
Next Topic:Map<Enum, Entity> table creation works (3 columns), query is wrong (2 values)
Goto Forum:
  


Current Time: Fri Dec 19 15:15:06 GMT 2014

Powered by FUDForum. Page generated in 0.01813 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software