Re: Negators for operators - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Negators for operators
Date
Msg-id CA+TgmoZdEFSc75LkhT297s+oARqdPdVBNTZ3PB2wEQrrX8-hNQ@mail.gmail.com
Whole thread Raw
In response to Negators for operators  (David Fetter <david@fetter.org>)
Responses Re: Negators for operators  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Perf Benchmarking and regression.
Next
From: Tom Lane
Date:
Subject: Re: Negators for operators