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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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