rds,
Frank
-Original Message-
From: Robert Haas [mailto:robertmh...@gmail.com]
Sent: Wednesday, January 12, 2011 11:10 AM
To: frank
Cc: Korry Douglas; Kevin Grittner; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #5816: index not used in function
On Mon, Jan 10, 2011 at 9:07 PM, fr
Frank, thanks for educating me.
-- Korry
> -Original Message-
> From: Korry Douglas [mailto:korry.doug...@enterprisedb.com]
> Sent: Sunday, January 09, 2011 2:34 PM
> To: frank
> Cc: 'Kevin Grittner'; pgsql-bugs@postgresql.org
> Subject: Re: [BUGS]
On Mon, Jan 10, 2011 at 9:07 PM, frank wrote:
> More can be said, but why one wants to defend a defect is quite beyond me.
I guess the question is whether you want to solve your problem or
improve PostgreSQL. If you want to solve your immediate problem, the
advice given thus far is probably enou
-Original Message-
From: Korry Douglas [mailto:korry.doug...@enterprisedb.com]
Sent: Sunday, January 09, 2011 2:34 PM
To: frank
Cc: 'Kevin Grittner'; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #5816: index not used in function
> We may have different perceptions
> We may have different perceptions of something being a 'bug'. I always
> have several simple ways of determining it. One of them is when a
> work-around is in the proposal. Yours is one.
It seems to me that the important question in this case is whether or not the
query produced the correct res
sage-
From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov]
Sent: Thursday, January 06, 2011 12:50 PM
To: pgsql-bugs@postgresql.org; frank
Subject: Re: [BUGS] BUG #5816: index not used in function
"frank" wrote:
> WHERE upper("thisColumn") like $1
The function's pla
"frank" wrote:
> WHERE upper("thisColumn") like $1
The function's plan is kept from one execution to another, and it
can't know what will be in the first parameter -- perhaps '%X%'? If
you build up the statement in a string and EXECUTE it, you might get
the desired behavior.
Anyway, next ti
The following bug has been logged online:
Bug reference: 5816
Logged by: frank
Email address: fr...@ros-i.com
PostgreSQL version: 8.3.7
Operating system: linux
Description:index not used in function
Details:
Linux: Linux 2.6.24-24-server #1 SMP Tue Jul 7 20:21:17 U
