Re: BUG #16615: Cannot determine type of Date for "is null" expression - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #16615: Cannot determine type of Date for "is null" expression
Date
Msg-id CAKFQuwaYggLSS9Q3fs6wZd7UGGQQtj3bhPazEZqmaDUAxwvSvQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16615: Cannot determine type of Date for "is null" expression  (yuanhang <yuanhang.zheng@qq.com>)
List pgsql-bugs
On Mon, Sep 14, 2020 at 12:02 AM yuanhang <yuanhang.zheng@qq.com> wrote:
2. I don’t understand why the type cannot be parsed in T_NullTest. It can be parsed when using the SQL below.

Equality is a binary operator so the unknown argument can be inferred from the known one.

Is Null is a unary operator so there is nothing available with which to infer a type.

David J.

pgsql-bugs by date:

Previous
From: yuanhang
Date:
Subject: Re: BUG #16615: Cannot determine type of Date for "is null" expression
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #16486: Prompted password is ignored when password specified in connection string