On 1/24/19 7:32 AM, Geoff Winkless wrote:
> 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?
Getting in a hurry/distracted.
I wrote out the above test case in psql and with tab completion it is
easy to get to:
delete from delete_test where
and then forget the 'field =' part. Though my more common mistake along
that line is:
delete from delete_test;
At any rate, if it can be done it will be done.
>
> G
>
--
Adrian Klaver
adrian.klaver@aklaver.com