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

Re: Using upper() / decode() together

From: "Ross Gohlke" <ross(at)grinz(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Using upper() / decode() together
Date: 2005-03-01 03:54:08
Message-ID: 50385. (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I get this error:

ERROR:  cannot cast type bytea to character varying

Any ideas?

> Does doing something like (untested):
> SELECT * from table where upper(decode(field,'base64')::varchar) like
> work for you?
> Sean

Ross Gohlke
ross at grinz dot com

In response to


pgsql-novice by date

Next:From: Todd LewisDate: 2005-03-01 09:14:25
Subject: Re: Import csv file into multiple tables in Postgres
Previous:From: Sean DavisDate: 2005-02-28 14:08:10
Subject: Re: Using upper() / decode() together

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