| From: | <Eugen(dot)Konkov(at)aldec(dot)com> |
|---|---|
| To: | <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | FEATURE: Reuse temporary tables |
| Date: | 2008-05-20 10:53:26 |
| Message-ID: | 000601c8ba67$bc7dd4a0$1200a8c0@kharkov.localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
ACTUAL:
select * from (select atc.id, ats.test_suit_type_id from akh_testing_conf atc left join akh_test_suit ats on ats.id = atc.test_suit_id) tc1
left join (select atc.id, ats.test_suit_type_id from akh_testing_conf atc left join akh_test_suit ats on ats.id = atc.test_suit_id) tc2 on tc2.test_suit_type_id = tc1.test_suit_type_id
where tc1.id = 3879
FEATURED:
select * from (select atc.id, ats.test_suit_type_id from akh_testing_conf atc left join akh_test_suit ats on ats.id = atc.test_suit_id) tc1
left join tc1 tc2 on tc2.test_suit_type_id = tc1.test_suit_type_id
where tc1.id = 3879
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mikael Omma | 2008-05-20 13:13:21 | BUG #4184: Undefined reference to 'SSL_CTX_set_client_cert_db' in /usr/lib/libpq.so.5 |
| Previous Message | Eugen.Konkov | 2008-05-20 07:55:58 | Re: Win32: Postgre 8.3.1 does not work with Active perl 5.10 |