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

Using upper() / decode() together

From: "Ross Gohlke" <ross(at)grinz(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Using upper() / decode() together
Date: 2005-02-25 01:03:50
Message-ID: 50740.4.46.199.59.1109293430.squirrel@4.46.199.59 (view raw or flat)
Thread:
Lists: pgsql-novice
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






Responses

pgsql-novice by date

Next:From: operationsengineer1Date: 2005-02-25 20:02:17
Subject: Boolean
Previous:From: Tom LaneDate: 2005-02-24 22:47:44
Subject: Re: [NOVICE] Question on TRUNCATE privleges

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