Re: Commutation of array SOME/ANY and ALL operators

2024-10-24 Thread Matthew Morrissette Vance
> Inventing commutator operators for LIKE etc could be a path of > much less resistance (unless the operator names get bikeshedded > to death). Are there really that many that people need? > A quick query of pg_operator suggests that the LIKE/regex family > is the bulk of the problem for real-worl

Re: Commutation of array SOME/ANY and ALL operators

2024-10-23 Thread Tom Lane
Matthew Morrissette Vance writes: > If instead, PostgreSQL could support the commutation of the `SOME/ANY` and > `ALL` operators so that the `ANY(array)` could be on both sides of the > provided operator, it would allow for this kind of searching natively. > Firstly, would a PR that enhanced Post