Обсуждение: Defining my own operator's precedence

Поиск
Список
Период
Сортировка

Defining my own operator's precedence

От
"Pierre Racine"
Дата:
Hi,

I have develop my own data type and my own operators on this data type. I 
could not find how to tell PostgreSQL which precedence I want to assign to 
my operator. For example, I want my unary operator "~" to have a higher 
precedence than my "+" operator. For now I have to use parenthesis to avoid 
ambiguity. I would prefer being able to define implicit precedence.

Root




Re: Defining my own operator's precedence

От
Martijn van Oosterhout
Дата:
On Sun, Mar 05, 2006 at 05:13:11PM +0000, Pierre Racine wrote:
> Hi,
>
> I have develop my own data type and my own operators on this data type. I
> could not find how to tell PostgreSQL which precedence I want to assign to
> my operator. For example, I want my unary operator "~" to have a higher
> precedence than my "+" operator. For now I have to use parenthesis to avoid
> ambiguity. I would prefer being able to define implicit precedence.

Sorry, not possible. :( You pretty much have to choose operators whose
precedence matches what you want.

Have a nice day,

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.