postgresql 创建bool自动转换为int2

若疆赤云online

于 2024-11-15 10:40:23 发布

阅读量453

点赞数 1

CC 4.0 BY-SA版权

分类专栏： postgresql 文章标签： postgresql

本文链接：https://blog.youkuaiyun.com/now19930616/article/details/143788567

postgresql 专栏收录该内容

3 篇文章

订阅专栏

CREATE OR REPLACE FUNCTION "public"."boolean_to_smallint"("b" bool)
  RETURNS "pg_catalog"."int2" AS $BODY$
    BEGIN
            RETURN (b::boolean)::bool::int;
    END;
$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;


CREATE CAST (boolean AS smallint) WITH FUNCTION boolean_to_smallint(boolean) AS implicit;