2018-02-28 16:13 GMT+01:00 Pavel Stehule <pavel.steh...@gmail.com>: > Hi > > 2018-02-28 16:06 GMT+01:00 <n.zhuch...@postgrespro.ru>: > >> n.zhuch...@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 > >
