Re: Casting Integer to Boolean in assignment - Mailing list pgsql-general

From Geoff Winkless
Subject Re: Casting Integer to Boolean in assignment
Date
Msg-id CAEzk6fepSm-ywhOGx6QCWmaWqoq00MfVcnu5T27_+ScMjRzWRw@mail.gmail.com
Whole thread Raw
In response to Re: Casting Integer to Boolean in assignment  (Geoff Winkless <pgsqladmin@geoff.dj>)
List pgsql-general
On Thu, 24 Jan 2019 at 15:32, Geoff Winkless <pgsqladmin@geoff.dj> wrote:
> DELETE FROM <tablename> WHERE <integer>;
>
> What would you be thinking that that ought to do?

To be fair, I suppose that accidentally missing out a test but
including an integer field

DELETE FROM <tablename> WHERE <integerfieldname>;

could do this. Not something I've ever done, but at least I see how
it's possible.

*shrug* I should reiterate, it's just my opinion, I'm certainly not
arguing for it to be changed, although I would be pretty upset if the
existing ability to change the behaviour were removed.

Geoff


pgsql-general by date:

Previous
From: Geoff Winkless
Date:
Subject: Re: Casting Integer to Boolean in assignment
Next
From: Adrian Klaver
Date:
Subject: Re: Casting Integer to Boolean in assignment