| 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: | Whole Thread | Raw Message | 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
| 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 |