Using upper() / decode() together
От
Ross Gohlke
Тема
Using upper() / decode() together
Дата
Msg-id
50740.4.46.199.59.1109293430.squirrel@4.46.199.59
Список
Дерево обсуждения
Using upper() / decode() together "Ross Gohlke" <ross@grinz.com>
I'm using postgres as the backend of a custom PHP Web application. Text
is base64_encode-d in php, then stored in varchar fields in postgres.
I'm trying to do this:
SELECT * from table where upper(decode(field,'base64')) like
upper('%sometext%');
I keep getting this error:
ERROR: function upper(bytea) does not exist
HINT: No function matches the given name and argument types. You may
need to add explicit type casts.
Is there any way to use upper in this manner?
--
Ross Gohlke
ross at grinz dot com
В списке pgsql-novice по дате отправления