Re: IS as a binary operator

2023-02-25 Thread Tom Lane
david wheeler writes: > I guess there’s no interest in adding support for `IS` as basically an alias > for `IS NOT DISTINCT FROM`? (and `IS NOT` for `IS DISTINCT FROM`) Seems like it'd be impossibly ambiguous with the various sorts of "x IS FOO" constructs that SQL keeps adding. We'd have to ma

IS as a binary operator

2023-02-25 Thread david wheeler
Heya folks, Recently I've been using a Kotlin library SQLDelight which is great but has some issues with PostgreSQL support. In particular, for null parameters it converts `=` to `IS` - and it treats `IS` as a binary operator (rather than `