Postgres User wrote:
Yes that works, but the whole point of the exercise is replace many OR
statements with 1 regex expression. So it's not what I'm looking for.
Why do you want it done this way?
You can build an array of strings to check and use an in clause.
Using php :
$checks = array('AA', 'BA');
$query = "select * from table where name in ('" . implode("','",
$checks) . "')";
and it should use an index (up to a point anyway).
--
Postgresql & php tutorials
http://www.designmagick.com/
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend