Search Postgresql Archives

Why are no NEGATORS defined in the standard operators

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello,

 

while trying to bake my own fixedpoint datatype I noticed the definition for ="" 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

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux