postgresql - COALESCE 类型字符变化和数字不能匹配

Question

我有一张名为 table1 的表带列Gender varchar(10)和 Team numeric .

create table table1 (
ID integer
Gender varchar(10),
Team numeric
);

insert into table1 (ID,Gender,Team) values
(1,'M',NULL),
(2,NULL,10),
(3,NULL,6),
(4,''F',NULL),
(5,NULL,3);

我想创建一个新专栏 Nxt从字符串或整数的任何列返回不为空的行。

栏目 Nxt看起来像: M,10,6,F,3
我试过这个:

select coalesce(Gender,Team) as value from table1;

它返回此错误:

COALESCE types character varying and numeric cannot be matched

Answer 1

尝试将列转换为文本

    select coalesce(Gender,Team::text) as value from table1;