Re: Casting Integer to Boolean in assignment

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Alexandre GRAIL <postgresql(dot)general(at)augure(dot)net>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Casting Integer to Boolean in assignment
Date: 2019-01-24 15:11:22
Message-ID: 17453.1548342682@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Geoff Winkless <pgsqladmin(at)geoff(dot)dj> writes:
> On Thu, 24 Jan 2019 at 14:28, David G. Johnston
> <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>> To assist developers in avoiding the writing of buggy queries.

> Amazing how many of these developers find this a hindrance. If only
> they could see how helpful we're being to them.

People don't generally post to the lists after a type-mismatch error
catches a typo for them. So it's pretty hard to tell about "how
many" developers would find one behavior more useful than the other.
It is safe to say, though, that the same developer complaining today
might have their bacon saved tomorrow.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2019-01-24 15:13:28 Re: [pgbackrest] Expiring the last backup?
Previous Message Ron 2019-01-24 15:09:24 Re: Casting Integer to Boolean in assignment