Re: differences between <> and != when using signed values on the right hand side

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: David Hunnisett <david(dot)hunnisett(at)probit(dot)io>
Cc: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: differences between <> and != when using signed values on the right hand side
Date: 2024-05-16 14:39:43
Message-ID: CAKFQuwaUT_9i+ni=CVsnxWjzWyOOkv35AmttVR_d-N9zM3e6yw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thursday, May 16, 2024, David Hunnisett <david(dot)hunnisett(at)probit(dot)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:

https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-OPERATORS

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

David J.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2024-05-16 15:27:18 Re: BUG #18467: postgres_fdw (deparser) ignores LimitOption
Previous Message PG Bug reporting form 2024-05-16 10:55:03 BUG #18469: OOM occurs and backend processes are kept in Zombie state.