Re: != should give error?

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: != should give error?
Дата
Msg-id CAMsr+YF7ocp4ZunCjB_GSFc-=uqyAXoCgWxw-j7hgHRt66Tm0g@mail.gmail.com
обсуждение исходный текст
Ответ на != should give error?  (Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>)
Ответы Re: != should give error?  (Mikael Kjellström <mikael.kjellstrom@mksoft.nu>)
Список pgsql-hackers
On 21 December 2017 at 14:43, Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com> wrote:
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)


One-factorial is one, so it's correct.

test=> SELECT 1!, 2!, 3!;
 ?column? | ?column? | ?column? 
----------+----------+----------
        1 |        2 |        6
(1 row)

test=> SELECT (1 !) = 1;
 ?column? 
----------
 t
(1 row)

test=> \do+ !
                                      List of operators
   Schema   | Name | Left arg type | Right arg type | Result type |  Function   | Description 
------------+------+---------------+----------------+-------------+-------------+-------------
 pg_catalog | !    | bigint        |                | numeric     | numeric_fac | factorial
(1 row)




--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: Using ProcSignal to get memory context stats from a running backend
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Using ProcSignal to get memory context stats from a runningbackend