Bo Lorentsen <bl@netgroup.dk> writes:
> To me it sounds like an index lookup is a one time a query (not per row)
> thing, but I don't understand why.
I can't explain it any more clearly than Florian did:
http://archives.postgresql.org/pgsql-general/2005-01/msg00769.php
regards, tom lane