Postgres Pro
Downloads
Home   >   mailing lists

Re: [PATCH] Allow field set from a joined query - Mailing list pgsql-odbc

From Inoue, Hiroshi
Subject Re: [PATCH] Allow field set from a joined query
Date
Msg-id 9a52594b-260e-e7b4-60ee-90e72bdc4bce@dream.email.ne.jp
Whole thread Raw
In response to Re: [PATCH] Allow field set from a joined query  (Russell F <russman7474@gmail.com>)
Responses Re: [PATCH] Allow field set from a joined query
List pgsql-odbc
Tree view
Hi Russell,

Thanks.
I would take care of your patches.

The current driver is not expected to update/delete result sets
with multiple tables. Please show me the examples.

regards,
Hiroshi Inoue

On 2020/05/28 7:31, Russell F wrote:
Expanded this patch some to fix some other parsing issues with joins.

Also available here:


Russell

On Tue, May 26, 2020 at 5:53 PM Russell F <russman7474@gmail.com> wrote:
Hi All,

I made this quick change to allow setting fields when a query has an inner or outer join in it. I'm not exactly sure why the check disallowed joins containing the "X JOIN", such as "LEFT JOIN" or "INNER JOIN", but allowed the variant "JOIN". Unless I missed something. Maybe an artifact from old code?

Also, I added an option in the build to specify a postgres installation directory, since some may just have the postgres bins built but not installed.

thanks,
Russell

pgsql-odbc by date:

Previous
From: Russell F
Date:
Subject: Re: [PATCH] Allow field set from a joined query
Next
From: Russell F
Date:
Subject: Re: [PATCH] Allow field set from a joined query