Thread: Operator whit word

Operator whit word

From
"Thiago Ventura"
Date:
The manual say:
The operator name is a sequence of up to NAMEDATALEN-1 (63 by default)
characters from the following list:
+ - * / < > = ~ ! @ # % ^ & | ` ?

So, how I could create a operator with word ( i.e. LIKE ) ?

Re: Operator whit word

From
Alvaro Herrera
Date:
Thiago Ventura escribió:
> The manual say:
> The operator name is a sequence of up to NAMEDATALEN-1 (63 by default)
> characters from the following list:
> + - * / < > = ~ ! @ # % ^ & | ` ?
>
> So, how I could create a operator with word ( i.e. LIKE ) ?

You can't.  (Unless you hack Postgres' source code).

--
Alvaro Herrera                        http://www.advogato.org/person/alvherre
"The ability to monopolize a planet is insignificant
next to the power of the source"