Re: Boolean operators without commutators vs. ALL/ANY

On 06/17/2011 10:20 AM, Alvaro Herrera wrote:
> alvherre=# \doS ~
>
> Listado de operadores
> Esquema | Nombre | Tipo arg izq | Tipo arg der | Tipo resultado | Descripción
> ------------+--------+--------------+--------------+----------------+--------------------------------------------
> ...
> pg_catalog | ~ | text | text | boolean | matches regular expression, case-sensitive
>
> Note that there's no way to tell which is the regex here. It'd be a lot
> better if the description was explicit about it. (Or, alternatively,
> use a different data type for regexes than plain text ... but that has
> been in the Todo list for years ...)

+1 for improving the description.

>
> Have ~ keep its existing semantics, use ~= for the commutator? There
> are a lot more chars allowed in operator names anyway, it doesn't seem
> to me like we need to limit ourselves to ~, = and @.

Yeah, maybe something like ~< for the commutator. (I know, we're
bikeshedding somewhat.)

> I *do* like the idea of having commutate-ability for ANY/ALL, having
> needed it a couple of times in the past.
>

Indeed. me too.

cheers

andrew