"Lada 'Ray' Lostak" <ray@unreal64.net> writes:
> EXPLAIN SELECT
> id,parent,alias,aliasfull,name,comment,type,typeflags,flags,cluster,viewprio
> r FROM dtditems WHERE cluster IN (42)
> QUERY PLAN Seq Scan on dtditems (cost=0.00..253.40 rows=150 width=84)
> Filter: ("cluster" = 42)
Um ... what is the datatype of the "cluster" column? I'm betting it's
int8 or int2, not int4 which is what your constant is ...
regards, tom lane