Skip site navigation (1) Skip section navigation (2)

Re: empty string causes planner to avoid index. Makes me sad.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Amiel <becauseimjeff(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: empty string causes planner to avoid index. Makes me sad.
Date: 2009-11-27 22:00:26
Message-ID: 20827.1259359226@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Jeff Amiel <becauseimjeff(at)yahoo(dot)com> writes:
> hmm...ok...planner is not using the index effectively (as effectively as when a non-empty value is passed in)

You didn't show us any evidence of that, either.  Both of your test
cases are using the index.

			regards, tom lane

In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2009-11-27 22:15:41
Subject: Re: Cannot allocate memory for output buffer
Previous:From: Jeff AmielDate: 2009-11-27 21:41:36
Subject: Re: empty string causes planner to avoid index. Makes me sad.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group