Support for APPLY using LATERAL JOIN

Support for APPLY using LATERAL JOIN

Postby 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?
uncqsun
 
Posts: 1
Joined: Mon 14 Jul 2014 09:16

Re: Support for APPLY using LATERAL JOIN

Postby Shalex » Tue 15 Jul 2014 10:57

Thank you for your request. We will investigate the question and notify you about the result.
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44

Re: Support for APPLY using LATERAL JOIN

Postby 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/postgresql/download.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.
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL