More efficient INs when comparing two columns

From: "Magnus Naeslund(t)" <mag(at)fbab(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: More efficient INs when comparing two columns
Date: 2005-09-20 18:45:21
Message-ID: 433058C1.1010609@fbab.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I was thinking if this was possible in some way..
I have this table where we have X and Y coordinates, and i need to
select several in one go.

# select * from xy where (x = 1 and y = 2) or (x = 2 and y = 2);

This works but are not so nice looking.
It would be nice to be able to do it like this:

# select * from xy where (x, y) in ((1, 2), (2, 2));

But that doesn't work.
A funny thing is that this works:

# select * from xy where (x, y) = (1, 2);

What's the most efficient way of doing these kind of selects?
A multicol index on x and y is what we currently do and the first select
above...

Regards,
Magnus

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Olly Betts 2005-09-20 19:44:18 Re: Slow search.. quite clueless
Previous Message Dean Gibson (DB Administrator) 2005-09-20 18:42:07 Re: running vacuum in scripts