Support for APPLY using LATERAL JOIN

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
uncqsun
Posts: 1
Joined: Mon 14 Jul 2014 09:16

Support for APPLY using LATERAL JOIN

Post by uncqsun » Mon 14 Jul 2014 09:30

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
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Support for APPLY using LATERAL JOIN

Post by Shalex » Tue 15 Jul 2014 10:57

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

Shalex
Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Re: Support for APPLY using LATERAL JOIN

Post by Shalex » Thu 04 Sep 2014 15:04

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.

Post Reply