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.