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