barsbek/lateral.sql

Created March 19, 2018 14:16

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/barsbek/fc91bd6894cb8ad0ac5ea101cfcb87b5.js"></script>
Save barsbek/fc91bd6894cb8ad0ac5ea101cfcb87b5 to your computer and use it in GitHub Desktop.

Download ZIP

postgresql: access preceding sub-selects in from clause

Raw

lateral.sql

select * from t1, lateral (select * from t2 where t2.id = t1.id);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment