The GREATEST and LEAST functions select the largest or smallest value from a list of any number of expressions. The expressions must all be convertible to a common data type, which will be the type of the result (see Section 10.5 for details).
English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
GREATEST and LEAST functions select the largest or smallest value from a list of any number of expressions. The expressions must all be convertible to a common data type, which will be the type of the result (see Section 10.5 for details).GREATEST(value [, ...])The
GREATEST and LEAST functions select the largest or smallest value from a list of any number of expressions. The expressions must all be convertible to a common data type, which will be the type of the result (see Section 10.5 for details).Full definition and evidence JSON
center · PostgreSQL 18 · wiki-repair-20261023:ceb44768ee3ebb780e8db402a91610bef67ba12bcf3fd5185363307720616e20
Text language: en · wiki-repair-20261023:ceb44768ee3ebb780e8db402a91610bef67ba12bcf3fd5185363307720616e20