Re: Is the COMMUTATOR clause required for self commutative operators?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: btober(at)seaworthysys(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Is the COMMUTATOR clause required for self commutative operators?
Date: 2003-12-08 22:29:53
Message-ID: 23686.1070922593@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<btober(at)seaworthysys(dot)com> writes:
> Is omitting the COMMUTATOR option a problem at all in case of
> self-commutative operators?

At the moment it only really matters for operators that are used in
top-level WHERE clauses --- which lets out anything that doesn't return
boolean. But I'd say that as a matter of style, if the operator is
self-commutative you should mark it so. Some day the system might
pay attention.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brendan Jurd 2003-12-08 22:34:43 Re: Inheritance and foreign keys
Previous Message Stephan Szabo 2003-12-08 22:29:24 Re: Inheritance and foreign keys