subject:"\[GENERAL\] optimizing a query with sub select"

Re: [GENERAL] optimizing a query with sub select

2010-09-29 Thread Grzegorz Jaśkiewicz

Use JOIN sherlock. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] optimizing a query with sub select

2010-09-29 Thread Georgi Ivanov

Hi, I have this query SELECT * FROM v_material WHERE show_in_recent AND section_id IN ( SELECT s.id FROM section AS s, section AS s2 WHERE s2.id = 842 AND s.breadcrumb <@ s2.breadcrumb ) ORDER BY published_on DESC LIMIT 3;