Defining my own operator's precedence

Started by Pierre Racinealmost 20 years ago2 messages
#1Pierre Racine
racine_pierre@hotmail.com

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

#2Martijn van Oosterhout
kleptog@svana.org
In reply to: Pierre Racine (#1)
Re: Defining my own operator's precedence

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/

Show quoted text

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.