Re: BUG #18689: psql : operator "!=" do not behave like "<>"
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Rafia Sabih <rafia.pghackers@gmail.com>
Cc: jhecht@cirilgroup.com, pgsql-bugs@lists.postgresql.org
Date: 2024-11-05T14:56:22Z
Lists: pgsql-bugs
Rafia Sabih <rafia.pghackers@gmail.com> writes: > Thank you for reporting this. However I found that the lack of space in the > statement is causing this. > On trying it like select -1 != -1; it works fine. Right, see https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-OPERATORS particularly the bit about "A multiple-character operator name cannot end in + or -, unless ...". "!=-" will be treated as one operator, but "<>-" will not. regards, tom lane