Re: [PERFORM] Arrays and index scan

2006-04-28 Thread Tom Lane
Markus Schaber <[EMAIL PROTECTED]> writes: > However, the query planner seems to refuse to make index scans even with > 8.1: > testdb=# EXPLAIN SELECT * from streets WHERE link_id = ANY(ARRAY[1,2,3]); Yup, that was just done in HEAD a couple months ago. regards, tom lane

[PERFORM] Arrays and index scan

2006-04-28 Thread Markus Schaber
Hello, I'm searching for a comfortable way to get a variable-size bunch of user specified Objects via a single prepared statement, so I wanted to submit an ARRAY. However, the query planner seems to refuse to make index scans even with 8.1: testdb=# EXPLAIN SELECT * from streets WHERE link_id =