Re: != should give error?

On 2017-12-21 08:16, Craig Ringer wrote:

>     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)*
>     *
>     *
>
> One-factorial is one, so it's correct.

Yes, but I think he was expecting the behavior to be different from / 
not equal.  So he meant to write:

select * from tbl where col_a != 1;

I.e. col_a different from 1.

BTW isn't the "preferred" way of writing different from / not equal in 
SQL to use the <> operator?

/Mikael