Postgres Pro
Downloads
Home   >   mailing lists

Global setting for ORDER BY ... NULLS FIRST / LAST - Mailing list pgsql-sql

From Sebastien Flaesch
Subject Global setting for ORDER BY ... NULLS FIRST / LAST
Date
Msg-id DBAP191MB12893AA929975291A05E2938B0029@DBAP191MB1289.EURP191.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: Global setting for ORDER BY ... NULLS FIRST / LAST
List pgsql-sql
Tree view
Hello!

Is there a global PostgreSQL server setting or SQL session parameter that defines the default for   ORDER BY ... NULLS FIRST / LAST ?

Assuming that it would be something like "NULL is lowest value, or NULL is highest value", to get the expected behavior when using ASC/DESC options of ORDER BY ...

That would help to migrate to PostgreSQL for DB engines having a different default behavior regarding NULL sorting.

Thanks!
Seb

pgsql-sql by date:

Previous
From: Jian He
Date:
Subject: NORM(NO ORM) transform two one-many relationships into a single json.
Next
From: "David G. Johnston"
Date:
Subject: Re: Global setting for ORDER BY ... NULLS FIRST / LAST