Support for APPLY using LATERAL JOIN

[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?

[Shalex]

Thank you for your request. We will investigate the question and notify you about the result.

[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.