我将尝试创建如下示例所示的视图:
示例:
create view view1
as
select table1.col1,table2.col1,table3.col3
from table1
inner join
table2
inner join
table3
on
table1.col4 = table2.col5
/* Here col4 of table1 is of "integer" type and col5 of table2 is of type "varchar" */
/* ERROR: operator does not exist: integer = character varying */
....;
注意:在SQL Server中执行相同的查询,但在PostgreSQL中出现上述错误。
@Enumerated(EnumType.STRING)
注解。 - 8bitme