pg数据库整型与布尔互换

JefferyC2018

于 2023-09-08 11:42:24 发布

阅读量411

点赞数

文章标签： postgresql

本文链接：https://blog.csdn.net/gdczcwq/article/details/132757231

版权

update pg_cast set castcontext='a' where castsource ='boolean'::regtype and casttarget='integer'::regtype;
update pg_cast set castcontext='a' where castsource ='integer'::regtype and casttarget='boolean'::regtype;
CREATE OR REPLACE FUNCTION int_to_boolean(i smallint) RETURNS boolean AS $$
    BEGIN
            RETURN (i::smallint)::int::bool;
    END;
$$ LANGUAGE plpgsql;

CREATE CAST (smallint AS boolean) WITH FUNCTION int_to_boolean(smallint) AS ASSIGNMENT;
CREATE OR REPLACE FUNCTION boolean_to_int(i boolean) RETURNS smallint AS $$
    BEGIN
            RETURN (i::boolean)::bool::int;
    END;
$$ LANGUAGE plpgsql;

CREATE CAST (boolean AS smallint) WITH FUNCTION boolean_to_int(boolean) AS ASSIGNMENT;