nullslast(value: storable or ordering) -> ordering

Specify the ordering as nulls last when processing data.

This is used by ordered windowing functions (like lag and last), ordered aggregation functions (like array_agg) and the sort verb.

Domain

This is a scalar function (calculates a single output value for a single input row).

Categories

• Misc

Examples

Sort the dataset in with nulls appearing last in descending order by values in column foo.

Lists all users for each host, in order of ascending timestamp (default ordering) with nulls appearing last within each host assuming you have a table with columns timestamp, hostname and username.