slick-pg icon indicating copy to clipboard operation
slick-pg copied to clipboard

Published 20 hours ago • verified publisher icon tminglei

Support `JOIN LATERL`

Open yuanfeiz opened this issue 8 years ago • 2 comments

The definition of join lateral

The subquery specified on the RIGHT SIDE of the JOIN is evaluated for each row on the LEFT side of the JOIN.

It was release with v9.3, would be really handy to handle queries like "top N records of each category".

yuanfeiz avatar Feb 18 '17 05:02 yuanfeiz

Did some trying in branch lateral. But not successful yet.

tminglei avatar Feb 25 '17 04:02 tminglei

I looked at this a while ago as well. I think this is best done in Slick proper as a different join type as there are a few compiler phases which will get in the way.

ryandbair avatar Jul 08 '17 00:07 ryandbair