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.
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) |