Why are no NEGATORS defined in the standard operators - Mailing list pgsql-general

From Daniel Migowski
Subject Why are no NEGATORS defined in the standard operators
Date
Msg-id 41ED3F5450C90F4D8381BC4D8DF6BBDCAF46C6E0@EXCHANGESERVER.ikoffice.de
Whole thread Raw
Responses Re: Why are no NEGATORS defined in the standard operators
List pgsql-general

Hello,

 

while trying to bake my own fixedpoint datatype I noticed the definition for =(int8,int8) to be

 

CREATE OPERATOR =(

  PROCEDURE = int8eq,

  LEFTARG = int8,

  RIGHTARG = int8,

  COMMUTATOR = =,

  RESTRICT = eqsel,

  JOIN = eqjoinsel,

  HASHES,

  MERGES);

 

in PostgreSQL 9.5, but I wonder, why there is no NEGATOR clause defined here? According to the docs it should help to add

 

  NEGATOR = <>

 

In query optimization. Is there some reason for it? Or is it a Bug in pgAdmin III that the negator is not shown?

 

Regards,

Daniel Migowski

 

pgsql-general by date:

Previous
From: Eduardo Morras
Date:
Subject: Re: [HACKERS] Online DW
Next
From: Thomas Kellerer
Date:
Subject: pgAdmin 4 beta not working on Windows 10