Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
ars
on Dec 2, 2014
|
parent
|
context
|
favorite
| on:
PostgreSQL’s New LATERAL Join Type
So it seems this does the same thing as putting the subquery in the list of columns to return, except more efficient.
i.e.
SELECT a, (SELECT b FROM ...) b FROM ....
tracker1
on Dec 3, 2014
[–]
Kind of.. it's more expensive than a direct join, but you can do more with it. AFAIK it's syntactic sugar around a correlated sub-query... It may be slightly more efficient now too. It should probably be used sparingly and over limited result sets.
wireprotocol
on Dec 3, 2014
|
parent
[–]
I think it goes beyond syntax sugar, but perhaps there's a transformation between them that I'm not aware of.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
i.e.