Re: Direct converting numeric types to bool

Hi

2018-02-28 16:06 GMT+01:00 <n(dot)zhuchkov(at)postgrespro(dot)ru>:

> n(dot)zhuchkov(at)postgrespro(dot)ru писал 2018-02-28 18:04:
>
> 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.
>>
>
Looks little bit obscure to upstream code (can lives as extension outside)

all work can be done be function

CREATE OR REPLACE FUNCTION public.to_bool(anyelement)
RETURNS boolean
LANGUAGE sql
IMMUTABLE STRICT
AS $function$
select $1::int::boolean $function$

I really doesn't see any sense to allow cast from double to boolean

-1 from me

Regards

Pavel