BUG #18689: psql : operator "!=" do not behave like "<>"

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: jhecht(at)cirilgroup(dot)com
Subject: BUG #18689: psql : operator "!=" do not behave like "<>"
Date: 2024-11-05 11:23:57
Message-ID: 18689-7af3dd324b42205d@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18689
Logged by: Joël HECHT
Email address: jhecht(at)cirilgroup(dot)com
PostgreSQL version: 15.6
Operating system: CentOS Linux release 7.9
Description:

Hello,

according to the documentation, operators != and <> are supposed to be
interchangeable.
But when operator "!=" is followed by a negative number, the request failed
with an error "No operator matches the given name".

Here is how to reproduce the issue directly with psql :

[postgres(at)d04f96727d36 ~]$ psql
psql (15.6)
Type "help" for help.

postgres=# select -1<>-1;
?column?
----------
f
(1 row)

postgres=# select -1!=-1;
ERROR: operator does not exist: integer !=- integer
LINE 1: select -1!=-1;
^
HINT: No operator matches the given name and argument types. You might need
to add explicit type casts.
postgres=#

Regards.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Daniel Gustafsson 2024-11-05 12:47:40 Re: BUG #18688: _LSOpenURLsWithCompletionHandler() failed with error -54. (1)
Previous Message PG Bug reporting form 2024-11-05 08:57:19 BUG #18688: _LSOpenURLsWithCompletionHandler() failed with error -54. (1)