Hi,
On Tue, Aug 10, 2021 at 11:13:03AM +0200, Daniel Gustafsson wrote:
> > On 10 Aug 2021, at 11:10, Andreas Karlsson <andreas@proxel.se> wrote:
> > What is he reason you want to add ^= is there any other databases
> > which uses ^= for inequality?
>
> I assume it's because of Oracle compatibility which AFAIK is the only
> database supporting ^=.
DB2 also supports (or supported) it, but it's deprecated:
https://www.ibm.com/docs/en/db2/9.7?topic=predicates-basic-predicate
We encountered it at least in one customer setting, so we added it to
db2fce:
https://github.com/credativ/db2fce/blob/master/db2fce.sql#L588
Michael
--
Michael Banck
Projektleiter / Senior Berater
Tel.: +49 2166 9901-171
Fax: +49 2166 9901-100
Email: michael.banck@credativ.de
credativ GmbH, HRB Mönchengladbach 12080
USt-ID-Nummer: DE204566209
Trompeterallee 108, 41189 Mönchengladbach
Geschäftsführung: Dr. Michael Meskes, Sascha Heuer, Geoff Richardson,
Peter Lilley
Unser Umgang mit personenbezogenen Daten unterliegt
folgenden Bestimmungen: https://www.credativ.de/datenschutz
