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.4.62.156.229.1109649248.squirrel@4.62.156.229 (view raw or flat)
Thread:
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
upper('%sometext%');
>
> work for you?
>
> Sean
>

Ross Gohlke
ross at grinz dot com






In response to

Responses

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