Re: Force index usage on bigint in PL/PGSQL

Federico Pedemonte <fepede@inwind.it> writes:
> The problem is that i'd like to "force" my plpgsql functions to use
> indexes.
> Is there  a way  I can rewrite  the following plpgsql  query to  use the
> quote-trick ?

> result record;
> orain alias for $1;     -- bigint
> orafin alias for $2;    -- bigint

If $1 and $2 are in fact declared as bigint, then you don't have a
problem.

            regards, tom lane