EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

outer join problem  XML

Forum Index » GridSQL - General
Author Message
[Post New]03/12/2008 19:07:19
    Subject: outer join problem
[Up]
Don_N

New member

Joined: 03/12/2008 17:15:20
Messages: 9
Offline
create table t1 (col1 int) replicated;

create table t2 (col1 int) replicated;

select * from t1
left join t2 on t2.col1 = t1.col1
where t2.col1 is null

Error:
SQLException: ERROR: Can not prepare request: null
[Post New]04/12/2008 04:11:44
    Subject: Re:outer join problem
[Up]
Atul_D

New member

Joined: 21/03/2008 01:55:32
Messages: 9
Offline
Hi Don,
I suspect you have an old version of GridSQL. The outer join query works fine with the latest code from the CVS.

--
Atul
 
Forum Index » GridSQL - General
Go to:   
Powered by JForum 2.1.8 © JForum Team