From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "'Hiroshi Inoue'" <Inoue(at)tpf(dot)co(dot)jp>, "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk> |
Cc: | "'Jean-Michel POURE'" <jm(dot)poure(at)freesurf(dot)fr>, "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | RE: Access '97 {oj ...} Left Join |
Date: | 2001-04-11 18:44:39 |
Message-ID: | 8568FC767B4AD311AC33006097BCD3D61A2AA3@woody.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> -----Original Message-----
> From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
> Sent: 11 April 2001 11:42
> To: Henshall, Stuart - WCP
> Cc: 'Jean-Michel POURE'; 'pgsql-odbc(at)postgresql(dot)org'
> Subject: Re: [ODBC] Access '97 {oj ...} Left Join
>
>
> "Henshall, Stuart - WCP" wrote:
> >
> > Oh, that explains it :)
> > As a quick query why does the ODBC driver report them as
> available? As this
> > information is normally used by programs to determine if
> outer joins can be
> > used then surely they should be reported as not working,
> IMHO (I'm guessing
> > that humans read the docs to find a db's features). If this
> where the case
> > then IIRC Access '97 would use its own method of performing
> the join (which
> > is inefficient, but works).
>
> It seems you are right.
> I would change the driver report after the release of
> 7.1. Or hopefully I may be able to implement the {oj
> functionality.
The driver reports that it is OJ capable if it is connected to 7.1 or
higher. When I made the mods to the driver I tested successfully the OJs did
work (this *may* not be the case if the Parse Statements option is
selected).
What doesn't work is the {oj...} style syntax as Stuart reported (which
would have made my life easier when re-coding the SQL Wizard in pgAdmin!),
but this is because PostgreSQL doesn't support it, not the driver. The
following style syntax works a treat via ODBC:
SELECT * FROM foo
LEFT OUTER JOIN bar ON foo.col1 = bar.col1
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2001-04-12 00:33:38 | Re: Access '97 {oj ...} Left Join |
Previous Message | Dave Page | 2001-04-11 18:27:52 | ODBC Driver Installer |