Functions / Aggregate Functions

max

Computes the maximum of the non-null input values.

Reading PG 18current·documented in 27 of 27 versions, 7.1 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

max ( see text ) → same as input type

Computes the maximum of the non-null input values. Available for any numeric, string, date/time, or enum type, as well as bytea, inet, interval, money, oid, pg_lsn, tid, xid8, and also arrays and composite types containing sortable data types.

Version history 8

19 → 20 changed
18 → 19 changed
17 → 18 changed
14 → 15 changed
12 → 13 changed
9.3 → 9.4 changed
7.2 → 7.3 changed
7.1 → 7.2 changed

Definition snapshot: b7bd9cda · English manual source