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 -1 from me Regards Pavel
