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

Re: BUG #5126: convert_to preventing index scan

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Roman Kapusta <roman(dot)kapusta(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5126: convert_to preventing index scan
Date: 2009-10-21 18:34:46
Message-ID: 1256150086.13960.1.camel@vanquo.pezone.net (view raw or flat)
Thread:
Lists: pgsql-bugs
On Mon, 2009-10-19 at 11:05 +0000, Roman Kapusta wrote:
> I have table with bytea column, which is indexed (1)
> I want to use index during pattern matching (eg. dir like
> someDirectoryName
> || '/%'), but concatenation of two strings cause error (2)
> So I have to use function convert_to (converting text to bytea), but
> this
> has awful explain plan (3)

You haven't told us how the convert_to function is defined.


In response to

Responses

pgsql-bugs by date

Next:From: aihongweiDate: 2009-10-22 03:23:01
Subject: BUG #5131: The pgsql will lost
Previous:From: flamindragon1Date: 2009-10-21 16:51:49
Subject: BUG #5130: Failed to run initdb:1

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