Skip site navigation (1) Skip section navigation (2)

Re: Curious Join issue causing an E_FAIL error (with odbc

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: s(dot)vanroye(at)easytowork(dot)nl
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Curious Join issue causing an E_FAIL error (with odbc
Date: 2006-11-13 04:48:22
Message-ID: 4557F916.1040306@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Stijn Vanroye wrote:
> Hi List,
> 
> I have experienced a strange issue today: when executing a query with a 
> 3-level join in it I got an E_FAIL error in my client software. I did 
> manage to "fix" it but I still find it strange.
> 
> Suppose you have the following situation:
> 
> there are three tables A,B and C (quite dumb names I know)
> 
> and the following query:
> 
> select
> <some fields>,
> C.id
> from
> A
> left join B on (A.fkB_id=B.id)
> left join C on (b.fkC_id=C.id)
> 
> The above query produces the error.

Could you show me the whole code ?

regards,
Hiroshi Inoue

In response to

Responses

pgsql-odbc by date

Next:From: Stijn VanroyeDate: 2006-11-13 08:42:44
Subject: Re: Curious Join issue causing an E_FAIL error (with odbc
Previous:From: Hiroshi InoueDate: 2006-11-12 23:44:05
Subject: Re: Serial columns and ADO

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group