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. (view raw, whole thread or download thread mbox)
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

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 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-2017 The PostgreSQL Global Development Group