nullsfirst(value: storable or ordering) -> ordering

Specify the ordering as nulls first 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 with nulls first in column foo.

Lists all users for each host, in order of ascending timestamp with nulls first within each
host assuming you have a table with columns timestamp, hostname and username.