| From: | "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] temporary indexes |
| Date: | 2006-02-28 18:08:37 |
| Message-ID: | 20060228180837.GA1593@uio.no |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
On Tue, Feb 28, 2006 at 11:55:32AM -0600, Kevin Grittner wrote:
>> Also, EXISTS works in situations where
>> you need to compare on multiple columns, so it is useful in many
>> situations where EXISTS or MIN/MAX techniques just don't work.
> Sorry. That should have read:
>
> EXISTS works in situations where
> you need to compare on multiple columns, so it is useful in many
> situations where IN or MIN/MAX techniques just don't work.
Can't you just do WHERE (foo,bar) IN ( SELECT baz,quux FROM table )? I'm
quite sure I've done that a number of times.
/* Steinar */
--
Homepage: http://www.sesse.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2006-02-28 18:12:41 | Re: Dead Space Map |
| Previous Message | Tom Lane | 2006-02-28 18:08:17 | Re: Dead Space Map |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2006-02-28 18:16:50 | Re: [PERFORM] temporary indexes |
| Previous Message | Tom Lane | 2006-02-28 18:06:56 | Re: [PERFORM] temporary indexes |