SQL query - Mailing list pgsql-general

From David G. Johnston
Subject SQL query
Date
Msg-id CAKFQuwbgFP8RyH8tXUgqeE6BTAZBn9OWpbnecd98SbtHg4HWAw@mail.gmail.com
Whole thread Raw
In response to SQL query  (Vikas Sharma <shavikas@gmail.com>)
List pgsql-general
On Thursday, April 18, 2019, Vikas Sharma <shavikas@gmail.com> wrote:
 The above was run without where clause.

There was no where clause thus every row has to be updated by definition...null and bool evaluates to either false or null since if bool is false the null doesn’t matter and if bool is true the result is unknown from the null.

David J.


pgsql-general by date:

Previous
From: Vikas Sharma
Date:
Subject: SQL query
Next
From: Adrian Klaver
Date:
Subject: Re: SQL query