Document incompatibility of comparison expressions with VARIADIC array arguments

Andrew Dunstan <andrew@dunslane.net>

Commit: 5e74a427854fa17babfbb0e22c4ca95e4f48f2fe
Author: Andrew Dunstan <andrew@dunslane.net>
Date: 2019-03-11T22:14:05Z
Releases: 12.0
Document incompatibility of comparison expressions with VARIADIC array arguments

COALESCE, GREATEST and LEAST all look like functions taking variable
numbers of arguments, but in fact they are not functions, and so
VARIADIC array arguments don't work with them. Add a note to the docs
explaining this fact.

The consensus is not to try to make this work, but just to document the
limitation.

Discussion: https://postgr.es/m/CAFj8pRCaAtuXuRtvXf5GmPbAVriUQrNMo7-=TXUFN025S31R_w@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/func.sgml modified +9 −0

Documentation touched

Discussion