Re: Direct converting numeric types to bool

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: n(dot)zhuchkov(at)postgrespro(dot)ru
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Direct converting numeric types to bool
Date: 2018-02-28 15:11:32
Message-ID: 2655.1519830692@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

n(dot)zhuchkov(at)postgrespro(dot)ru writes:
> Attached patch allow direct convertion of numeric types to bool like
> integer::bool.
> Supported types:
> - smallint;
> - bigint;
> - real;
> - double precision;
> - decimal(numeric).
> This functionality is helped with migration from Oracle.

I think you forgot to attach the patch, but in any case: is this
really a behavior we want? "Oracle has it" is not a good argument
in my view, nor do I recall people complaining that they need such
a behavior to migrate.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2018-02-28 15:12:15 Re: Incorrect comments in partition.c
Previous Message Robert Haas 2018-02-28 15:06:27 Re: [HACKERS] [POC] Faster processing at Gather node