| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Bitmap index scans use of filters on available columns |
| Date: | 2015-11-08 20:34:27 |
| Message-ID: | 5555.1447014867@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Jeff Janes <jeff(dot)janes(at)gmail(dot)com> writes:
> On Fri, Nov 6, 2015 at 7:15 PM, Tomas Vondra
> <tomas(dot)vondra(at)2ndquadrant(dot)com> wrote:
>> I've however also noticed that all the 'like' procedures are marked as not
>> leak proof, which is a bit unfortunate because that's the example from
>> Jeff's e-mail that started this thread.
> Is there a reason they aren't leak proof? I don't see that they have
> side effects, or that they can throw errors. What do they leak?
Huh?
regression=# select 'z' like '\';
ERROR: LIKE pattern must not end with escape character
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2015-11-08 21:17:39 | Re: Uh-oh: documentation PDF output no longer builds in HEAD |
| Previous Message | Jeff Janes | 2015-11-08 19:59:42 | Re: Bitmap index scans use of filters on available columns |