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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
