Itai Zukerman <[EMAIL PROTECTED]> writes:
>> Never leave out the "unimportant" stuff --- that's usually where you
>> went wrong ;-)
> OK, I've attached below the SQL I use to generate stuff and an
> interactive session with the "explain" etc.
Ah. Your problem is you need to mark sig_in() as IMMU
> Ah. Your problem is you need to mark sig_in() as IMMUTABLE, or at
> least [...]
That was it! Thanks!
For your enjoyment:
test=# select count(*) from x;
count
20
(1 row)
test=# explain analyze select * from x where y ~>= sig_in('{1,2,3,4,5}'::int4[]);
