| From: | Goran Thyni <goran(at)bildbasen(dot)se> |
|---|---|
| To: | vadim(at)sable(dot)krasnoyarsk(dot)su |
| Cc: | maillist(at)candle(dot)pha(dot)pa(dot)us, hackers(at)postgreSQL(dot)org |
| Subject: | Re: [HACKERS] subselect |
| Date: | 1998-01-05 13:28:25 |
| Message-ID: | 19980105132825.28962.qmail@guevara.bildbasen.se |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Vadim,
Unfortunately, not all subqueries can be handled by "normal" joins: NOT IN
is one example of this - joining by <> will give us invalid results.
What is you approach towards this problem?
I got an idea that one could reverse the order,
that is execute the outer first into a temptable
and delete from that according to the result of the
subquery and then return it.
Probably this is too raw and slow. ;-)
Personally, I was stuck by holydays -:)
Now I can spend ~ 8 hours ~ each day for development...
Oh, isn't it christmas eve right now in Russia?
best regards,
--
---------------------------------------------
Göran Thyni, sysadm, JMS Bildbasen, Kiruna
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Darren King | 1998-01-05 14:13:30 | Re: [PORTS] (void)NULL in macros and aix |
| Previous Message | Bruce Momjian | 1998-01-05 13:13:49 | Re: [HACKERS] include/config.h FOLLOWUP |