first, first_value

Returns the first input value.

Syntax

first( <expr> )
first_value( <expr> )

first returns the first value, including NULL. first_value returns the first non-NULL value.

Examples

VALUES (NULL), ('a'), ('b')
AGGREGATE first($0), first_value($0);