Negators for operators

From: David Fetter <david(at)fetter(dot)org>
To: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Negators for operators
Date: 2016-06-03 19:02:18
Message-ID: 20160603190218.GA23273@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Folks,

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?

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2016-06-03 19:03:39 Re: Change in order of criteria - reg
Previous Message Markus Wanner 2016-06-03 18:48:24 Re: IPv6 link-local addresses and init data type