"Tom Lane" <tgl@xxxxxxxxxxxxx> writes: > Simon Riggs <simon@xxxxxxxxxxxxxxx> writes: >> Perhaps we can have a parameter? >> default_null_sorting = 'last' # may alternatively be set to 'first' > > Not unless it's locked down at initdb time. Otherwise flipping the > value bars you from using every existing index ... including those > on the system catalogs ... which were made with the other setting. Surely if we added this we would also add explicit NULLS LAST clauses to all system catalog indexes and system views and make explicitly constructed scans in the backend use NULLS LAST. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings