pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
CREATE OPERATOR and precedence
2+ messages / 2 participants
[nested] [flat]

* CREATE OPERATOR and precedence
@ 2010-07-08 14:28  Marc Cousin <cousinmarc@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Marc Cousin @ 2010-07-08 14:28 UTC (permalink / raw)
  To: pgsql-docs

Hi,

I just got caught by a precedence problem with CREATE OPERATOR.

Obviously, it was mostly my fault (I didn't think of the precedence of my 
operator at all), but I didn't find anything in the CREATE OPERATOR 
documentation about it either.

From looking at the code, I think I understood that it has a very low 
precedence, but shouldn't it be specified in the documentation (so that at 
least distracted people like me think of precedence next time they create an 
operator :) ) ?

Cheers

Marc



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: CREATE OPERATOR and precedence
@ 2010-07-08 14:31  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Marc Cousin <cousinmarc@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2010-07-08 14:31 UTC (permalink / raw)
  To: Marc Cousin <cousinmarc@gmail.com>; +Cc: pgsql-docs

Marc Cousin <cousinmarc@gmail.com> writes:
> I just got caught by a precedence problem with CREATE OPERATOR.

> Obviously, it was mostly my fault (I didn't think of the precedence of my 
> operator at all), but I didn't find anything in the CREATE OPERATOR 
> documentation about it either.

CREATE OPERATOR has nothing to say on the subject because operator
precedences are hard-wired into the parser and can't be changed by
CREATE OPERATOR.  See

http://www.postgresql.org/docs/8.4/static/sql-syntax-lexical.html#SQL-PRECEDENCE

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2010-07-08 14:31 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-07-08 14:28 CREATE OPERATOR and precedence Marc Cousin <cousinmarc@gmail.com>
2010-07-08 14:31 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox