3 ms·
Sounds like what Oracle calls a "correlated subquery" is it the same thing?
by ams6110 12y ago
Sounds like what Oracle calls a "correlated subquery" is it the same thing?
- pjungwir 12y agoNo, Postgres has supported those for a long time. For example: SELECT * FROM employees e WHERE EXISTS (SELECT 1 FROM employee_projects ep WHERE ep.employee_id = e.id AND ep.project_id = 5) ; This new feature is a lot like correlated subqueries except you can put that nested SELECT into the FROM clause and still access the employees table.