在这里,我试图创建视图,如下例所示:
例子:
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中得到上述错误.