Hi, i have a simple question on indices and subselects. Lets say i have a table foo with a column id int8 as primary_key bar. If i do a
select * from foo where id = 10 then the index bar is used. if i do select * from foo where id in (10,20) then the index is used. but if id do select * from foo where id in ( select 10 ) then the index is not used. Can anyone explain me this. It is very important, because i have to do this subselect. thanks, as ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
