Postgres Pro
Downloads
Home   >   mailing lists

Re: configure postgtresql to order NULLS FIRST instead of the defaultNULLS LAST - Mailing list pgsql-novice

From David G. Johnston
Subject Re: configure postgtresql to order NULLS FIRST instead of the defaultNULLS LAST
Date
Msg-id CAKFQuwYMa32Gx2Gcj7pMbjDLEkpTCe0VXAsdp+JWLhWA=1mXuw@mail.gmail.com
Whole thread Raw
In response to RE: configure postgtresql to order NULLS FIRST instead of the defaultNULLS LAST  ("Vianello, Daniel A" <Daniel.Vianello@charter.com>)
List pgsql-novice
Tree view
On Friday, January 4, 2019, Vianello, Daniel A <Daniel.Vianello@charter.com> wrote:

 Or you could create views to do complex sorting on a table and have users use the view instead of the table, but that is still extra development per table, not your apparently desired global change of behavior.

Most views should not specify a sort order.  Client-sent queries should append order by according to their need in presenting the data to the user-side of the system.

David J. 

pgsql-novice by date:

Previous
From: "Vianello, Daniel A"
Date:
Subject: RE: configure postgtresql to order NULLS FIRST instead of the defaultNULLS LAST
Next
From: Stephen Froehlich
Date:
Subject: pg_upgrade on new boot / Where to mount filesystems for tablespaces /other zfs questions