Postgres Pro
Downloads
Home   >   mailing lists

Re: Direct converting numeric types to bool - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Direct converting numeric types to bool
Date
Msg-id CAFj8pRCwCcudDESw8Od5vuUELbLi=2G_7KbEQ1n4f2OTKSEr8g@mail.gmail.com
Whole thread Raw
In response to Re: Direct converting numeric types to bool  (n.zhuchkov@postgrespro.ru)
Responses Re: Direct converting numeric types to bool  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Tree view
Hi

2018-02-28 16:06 GMT+01:00 <n.zhuchkov@postgrespro.ru>:
n.zhuchkov@postgrespro.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

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Incorrect comments in partition.c
Next
From: Pavel Stehule
Date:
Subject: Re: Direct converting numeric types to bool