Re: Trying to fetch records only if preceded by at least another one

[Alexander Farber <alexander.farber@xxxxxxxxx>]

Thank you Michael -

On Fri, Oct 25, 2019 at 7:28 PM Michael Lewis <mlewis@xxxxxxxxxxx> wrote:

But it prints too many records: all moves cross-multiplied with each other.

As if I have forgotten to add 1 more condition to the JOIN LATERAL

LIMIT 1 inside your lateral should resolve that. Personally, I'd move that condition to EXISTS condition inside WHERE clause instead. Just a style thing as far as I know. 

How would you do that with EXISTS? I tried, but my query failed to compile

Regards

Alex