!<space>= should give error?

From: Rajkumar Raghuwanshi <rajkumar(dot)raghuwanshi(at)enterprisedb(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: !<space>= should give error?
Date: 2017-12-21 06:43:13
Message-ID: CAKcux6ns5QXmPVzokxBDgWdz1J4kDVbmEbWNcd7hqx+k_ngbmg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

with below query I am getting unexpected output. here !<space>= is behaving
as =
is this expected behaviour?

postgres=# create table tbl (col_a int, col_b int);
CREATE TABLE
postgres=# insert into tbl values (1,2);
INSERT 0 1
postgres=# insert into tbl values (2,1);
INSERT 0 1

*postgres=# select * from tbl where col_a ! = 1; col_a |
col_b-------+------- 1 | 2(1 row)*

postgres=# select * from tbl where col_a = 1;
col_a | col_b
-------+-------
1 | 2
(1 row)

Thanks & Regards,
Rajkumar Raghuwanshi
QMG, EnterpriseDB Corporation

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Craig Ringer 2017-12-21 06:49:28 Re: Using ProcSignal to get memory context stats from a running backend
Previous Message Haisheng Yuan 2017-12-21 06:33:56 Re: Bitmap table scan cost per page formula