SQL query

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Vikas Sharma <shavikas(at)gmail(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: SQL query
Date: 2019-04-18 17:00:08
Message-ID: CAKFQuwbgFP8RyH8tXUgqeE6BTAZBn9OWpbnecd98SbtHg4HWAw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday, April 18, 2019, Vikas Sharma <shavikas(at)gmail(dot)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.

In response to

  • SQL query at 2019-04-18 16:43:41 from Vikas Sharma

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-04-18 17:01:44 Re: SQL query
Previous Message Vikas Sharma 2019-04-18 16:43:41 SQL query