Commitfe60480

committed

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 undocumentedwas that the parser actually translates these into operators.Discussion:https://postgr.es/m/CAFj8pRBkvZ71BqGKZnBBG4=0cKG+s50Dy+DYmrizUKEpAtdc+w@mail.gmail.com

1 parent980a70b commitfe60480Copy full SHA for fe60480

File tree

+17

-1

lines changed

+17

-1

lines changed

Lines changed: 17 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -3565,7 +3565,23 @@ cast(-44 as bit(12)) <lineannotation>111111010100</lineannotation>`
`3565`	`3565`	`<literal>!~~</literal> and <literal>!~~*</literal> operators that`
`3566`	`3566`	`represent <function>NOT LIKE</function> and <function>NOT`
`3567`	`3567`	`ILIKE</function>, respectively. All of these operators are`
`3568`		`- <productname>PostgreSQL</productname>-specific.`
	`3568`	`+ <productname>PostgreSQL</productname>-specific. You may see these`
	`3569`	`+ operator names in <command>EXPLAIN</command> output and similar`
	`3570`	`+ places, since the parser actually translates <function>LIKE</function>`
	`3571`	`+ et al. to these operators.`
	`3572`	`+ </para>`
	`3573`	`+`
	`3574`	`+ <para>`
	`3575`	`+ The phrases <function>LIKE</function>, <function>ILIKE</function>,`
	`3576`	`+ <function>NOT LIKE</function>, and <function>NOT ILIKE</function> are`
	`3577`	`+ generally treated as operators`
	`3578`	`+ in <productname>PostgreSQL</productname> syntax; for example they can`
	`3579`	`+ be used in <replaceable>expression</replaceable>`
	`3580`	`+ <replaceable>operator</replaceable> ANY`
	`3581`	`+ (<replaceable>subquery</replaceable>) constructs, although`
	`3582`	`+ an <literal>ESCAPE</literal> clause cannot be included there. In some`
	`3583`	`+ obscure cases it may be necessary to use the underlying operator names`
	`3584`	`+ instead.`
`3569`	`3585`	`</para>`
`3570`	`3586`
`3571`	`3587`	`<para>`

Comments

(0)