Postgres Pro
Downloads
Home   >   mailing lists

Re: differences between <> and != when using signed values on the right hand side - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: differences between <> and != when using signed values on the right hand side
Date
Msg-id CAKFQuwaUT_9i+ni=CVsnxWjzWyOOkv35AmttVR_d-N9zM3e6yw@mail.gmail.com
Whole thread Raw
In response to differences between <> and != when using signed values on the right hand side  (David Hunnisett <david.hunnisett@probit.io>)
Responses Re: differences between <> and != when using signed values on the right hand side
List pgsql-bugs
Tree view
On Thursday, May 16, 2024, David Hunnisett <david.hunnisett@probit.io> wrote:
When using a signed comparison != does not behave like <> if the right hand side comparator is signed and there is no space between the comparator and the sign


This is not a bug.  You are seeing practical examples of the behavior documented here:


In short, a consequence of allowing users to define their own operators.

David J.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #18469: OOM occurs and backend processes are kept in Zombie state.
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #18467: postgres_fdw (deparser) ignores LimitOption