http://forums.enterprisedb.com/posts/list/7.page JForum - http://www.jforum.net
I created a view as
[code]create view v_test as
select *
from (select * from test ) a left join (select * from test2 ) b
on a.id = b.id
[/code]

When I selects from this view, the error comes out.

[color=red]ERROR: Failed to parse view statement: select * from (select * from test ) a left join (select * from test2 ) b on a.id = b.i[/color]

I checked the xsysviews table, the view statement missed some letters.

I corrected the view statement and selected from the view again, but I still got the same error.

I tried restart the server, then I got a new error.

[color=red]ERROR: Node 3 has aborted execution, cause is: org.postgresql.util.PSQLException : ERROR: each UNION query must have the same number of columns
Position: 363
QUERY: SELECT "TMPTT3_3"."id" as "id", "TMPTT3_3"."name" as "name", "TMPTT3_3"."password" as "password", "TMPTT3_3"."rq" as "rq", "TMPTT3_3"."id" as "EXPRESSION1", "TMPTT3_3"."name" as "EXPRESSION2", "TMPTT3_3"."password" as "EXPRESSION3", "TMPTT3_3"."rq" as "EXPRESSION4" FROM "TMPTT3_3" INNER JOIN "TMPTT5_2" ON ("TMPTT3_3"."id" = "TMPTT5_2"."id") UNI...[/color]


Does the gridsql cache the view statement?

Does gridsql support full join now?

Thanks.

Regards,
David]]> http://forums.enterprisedb.com/posts/preList/2533/9516.page http://forums.enterprisedb.com/posts/preList/2533/9516.page GMT