Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with index not being chosen inside PL/PgSQL function... - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem with index not being chosen inside PL/PgSQL function...
Date
Msg-id 29904.1197994272@sss.pgh.pa.us
Whole thread Raw
In response to Problem with index not being chosen inside PL/PgSQL function...  ("Weber, Geoffrey M." <Geoffrey.Weber@mcleodusa.com>)
Responses Re: Problem with index not being chosen inside PL/PgSQL function...
List pgsql-general
Tree view 
"Weber, Geoffrey M." <Geoffrey.Weber@mcleodusa.com> writes:
> The problem I'm having is in one particular spot where I'm trying to
> run a "parametized" query inside a PL/PgSQL function.

I wonder whether the parameter is actually of the same datatype as the
indexed column.

            regards, tom lane

pgsql-general by date:

Previous
From: Ted Byers
Date:
Subject: Re: logging arguments to prepared statements?
Next
From: "Weber, Geoffrey M."
Date:
Subject: Re: Problem with index not being chosen inside PL/PgSQL function...