Re: Force index usage on bigint in PL/PGSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Federico Pedemonte <fepede(at)inwind(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Force index usage on bigint in PL/PGSQL
Date: 2003-01-16 16:01:30
Message-ID: 15176.1042732890@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Federico Pedemonte <fepede(at)inwind(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Fiche 2003-01-16 16:16:27 Re: Unsolveable query?
Previous Message codeWarrior 2003-01-16 15:53:46 Re: three timestamps/table, use of 'now' in table creation statement