Page 1 of 1

Support for APPLY using LATERAL JOIN

Posted: Mon 14 Jul 2014 09:30
by uncqsun
Hello,

While evaluating the connector using an application that was already working with SQL Server, I've come across the following exception: "OUTER APPLY is not supported by PostgreSQL".

The same issue is described here.

My question is: do you currently have any plans of implementing this (in the near future) using the lateral join feature that's available starting with PostgreSQL 9.3?

Re: Support for APPLY using LATERAL JOIN

Posted: Tue 15 Jul 2014 10:57
by Shalex
Thank you for your request. We will investigate the question and notify you about the result.

Re: Support for APPLY using LATERAL JOIN

Posted: Thu 04 Sep 2014 15:04
by Shalex
The generation of LEFT JOIN LATERAL and CROSS JOIN LATERAL is supported for PostgreSQL 9.3 starting from the new (7.3.239) build of dotConnect for PostgreSQL.
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=3&t=30325.