Eclipse Community Forums: EclipseLink » Postgresql NULLS FIRST Order by

Home » Eclipse Projects » EclipseLink » Postgresql NULLS FIRST Order by(How to indicate NULLS FIRST in order by expression?)

Show: Today's Messages :: Show Polls :: Message Navigator

Postgresql NULLS FIRST Order by [message #842503]

Thu, 12 April 2012 11:02

Miguel Goncalves

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

Report message to a moderator

Re: Postgresql NULLS FIRST Order by [message #846657 is a reply to message #842503]

Mon, 16 April 2012 14:28

James Sutherland

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

Report message to a moderator

Re: Postgresql NULLS FIRST Order by [message #899652 is a reply to message #846657]

Wed, 01 August 2012 16:49

Jorge Bautista

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!

Report message to a moderator

Re: Postgresql NULLS FIRST Order by [message #899660 is a reply to message #899652]

Wed, 01 August 2012 17:21

James Sutherland

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

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 19:26:18 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter