如何查询非物理存在的字段

jeffychen

视图
-----
CREATE VIEW sampleView1 AS select id, name, 'cn' as "language" from table1

查询视图
---------
select * from sampleView1 where language='cn'

ERROR:  failed to find conversion function from "unknown" to text

language并不是物理存在的字段
谁知道如何解决这个问题呢？

jeffychen

解决方法
---------
强制定义非物理字段类型

CREATE VIEW sampleView1 AS select id, name, 'cn' as "language" from table1
=>;
CREATE VIEW sampleView1 AS select id, name,text  'cn' as "language" from table1
或者
CREATE VIEW sampleView1 AS select id, name, 'cn'::text as "language" from table1

问题解决