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 CAEzk6fdybWtW6KXrV0bjYY7=2jYDxY=nDmbZBxr4+F2hfBLhwg@mail.gmail.com
Whole thread Raw
In response to Re: Casting Integer to Boolean in assignment  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Casting Integer to Boolean in assignment  (Geoff Winkless <pgsqladmin@geoff.dj>)
Re: Casting Integer to Boolean in assignment  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
On Thu, 24 Jan 2019 at 15:28, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
> On 1/24/19 7:21 AM, Geoff Winkless wrote:
> > How could you even write a query like the one Thomas posted? It
> > doesn't even look remotely sensible.

> delete from delete_test where 1::boolean;

*chuckle*

You misunderstand me.

I mean, how can one write a query like that by mistake?

DELETE FROM <tablename> WHERE <integer>;

What would you be thinking that that ought to do?

G


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: How duplicate values inserted into the primary key column oftable and how to fix it
Next
From: Geoff Winkless
Date:
Subject: Re: Casting Integer to Boolean in assignment