Re: Direct converting numeric types to bool

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: Direct converting numeric types to bool
Дата
Msg-id CAFj8pRBnVqYNx8V1qmBL5GjOeu2jt6CUEayAZE7gV-yX9ZSa0w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Direct converting numeric types to bool  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Дерево обсуждения


2018-02-28 16:13 GMT+01:00 Pavel Stehule <pavel.stehule@gmail.com>:
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

Long time Oracle had not boolean, so some ugly tricks was necessary there. There are not reason do same in Postgres.
 

-1 from me

Regards

Pavel


В списке pgsql-hackers по дате отправления: