EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

NULLS FIRST|LAST doesn't work on Postgres Plus Advanced Server 8.3R2 ?  XML

Forum Index » Advanced Server
Author Message
Hans_Vandewiele

New member

Joined: 11 Mar 2010 06:00:38
Messages: 2
Offline

Hello,
I installed Postgres Plus Advanced Server 8.3R2 (for its Oracle compatibility reasons)
It seems the function "NULLS FIRST" or "NULLS LAST" doesn't work ("select a.column from table a order by a.column ASC NULLS FIRST).
I installed Postgres Plus Standard Server 8.4 (to test this functionality) and there is works fine.
Is this normal ?
Thanks,
Hans Vandewiele
Vibhor_K

Senior member
[Avatar]

Joined: 3 Jul 2009 09:46:15
Messages: 444
Offline

Currently 8.3R2 does not have "NULLS FIRST". However, this feature would be available in 8.4AS.

Also, you can use UNION All to control the Null behavior as given below:

Thanks & Regards,
Vibhor Kumar
Blog:http://vibhork.blogspot.com
[Email] [WWW]
Hans_Vandewiele

New member

Joined: 11 Mar 2010 06:00:38
Messages: 2
Offline

Thank you very much for the answer.
In the mean while I found another "work around" with :

select datum from table
order by nvl(datum,'01-01-0000')

Could be helpfull for someone ?

Hans
 
Forum Index » Advanced Server
Go to:   
Powered by JForum 2.1.8 © JForum Team