Re: Negators for operators

On Fri, Jun 3, 2016 at 3:02 PM, David Fetter <david@fetter.org> wrote:
> While constructing a somewhat hairy query with HAVING in it, I noticed
> that a lot of operators don't have negators, which would have been
> convenient for the class of queries I was constructing.  Further
> investigation showed that while 380 of the built-in operators had
> negators, 395 do not.
>
> For some fraction I'll investigate if warranted, a negator makes no
> sense.  For the rest, I'd like to propose adding negator operators
> prefixed with '!', just as we have for the negators of regex-like
> things.
>
> What say?

How about using NOT?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company