Doc: explain that LIKE et al can be used in ANY (sub-select) etc.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 25bf317ccd5aa6050f1f0ac6aa5ed48cb5c6e98c
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2020-03-23T16:42:15Z
Releases: 11.8
Doc: explain that LIKE et al can be used in ANY (sub-select) etc.

This wasn't stated anywhere, and it's perhaps not that obvious,
since we get questions about it from time to time.  Also undocumented
was that the parser actually translates these into operators.

Discussion: https://postgr.es/m/CAFj8pRBkvZ71BqGKZnBBG4=0cKG+s50Dy+DYmrizUKEpAtdc+w@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/func.sgml modified +17 −1

Documentation touched

Discussion