On 12.01.2013, at 07:10, Amit kapila <amit.kapila@xxxxxxxxxx> wrote: > You can try once with below query: > Select * from (SELECT a.id,b.value FROM table_a a, table_b b WHERE ... AND ... ) X where X.value=...; > > If this doesn't work can you send the Explain .. output for both queries(the query you are using and the query I have suggested) > > With Regards, > Amit Kapila. Hi and thank you! I will try this and let you know! T. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
