It appears that in the predicate close (WHERE id IN (foo)), foo cannot depend on other table (join or other). It must be a list. I anderstand why (this must be static).
I can build a string value, but in some case, I will have a milion key list.
Postgresql do not have limitation in query size, and IN(...) keys number.
But creating a partial index, with a query of bilion character length is not an issue ? It looks like a little dirty, not ?
Thanks for all