Consider a new matches operator
Activity
Christian Beikov July 6, 2016 at 5:12 PM
Just wanted to mention that there is an operator called IS DISTINCT FROM in SQL99 for that and add some links because I researched this topic a bit for
http://stackoverflow.com/questions/10416789/how-to-rewrite-is-distinct-from-and-is-not-distinct-from
https://blog.jooq.org/2012/09/21/the-is-distinct-from-predicate/
https://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/com.ibm.db2z10.doc.sqlref/src/tpc/db2z_distinctpredicate.html
https://wiki.postgresql.org/wiki/Is_distinct_from
http://www.firebirdsql.org/refdocs/langrefupd20-distinct.html
http://www.h2database.com/html/grammar.html#condition_right_hand_side
http://hsqldb.org/doc/guide/dataaccess-chapt.html#dac_sql_predicates
Steve Ebersole October 29, 2015 at 5:32 PM
MySQL has an operator for this concept : https://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#operator_equal-to
Maybe it makes sense to use that for familiarity sake?
Details
Assignee
Christian BeikovChristian BeikovReporter
Steve EbersoleSteve EbersoleComponents
Fix versions
Priority
Major
Details
Details
Assignee
Christian BeikovReporter
Steve EbersoleComponents
Fix versions
Priority
Major
The idea is basically a "is null or equals" operator. See
Including the MySQL operator, the complete list of possibilities include:
where a.name ~ 'steve'
where a.name (=) 'steve'
where a.name ?= 'steve'
where a.name <=> 'steve'
where a.name matches 'steve'