Re: interpret bytea output as text / double encode() - Mailing list pgsql-general

From Stefan Froehlich
Subject Re: interpret bytea output as text / double encode()
Date
Msg-id 20140606133758.GA601@Debian-60-squeeze-64-minimal
Whole thread Raw
In response to Re: interpret bytea output as text / double encode()  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
> > # select encode(encode(column, 'escape'), 'escape')

> Any  chance you can encode() into temp table then encode() the result.

Don't think so, PostgreSQL will recognize the temp column either as text
or as bytea and then refuse either the insert or the encode() because of
a type mismatch.

Any workaround for this would most likely solve my original problem
without the use of a temp table.

Stefan


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Trigger to convert UNIX time to timestamp without time zone.
Next
From: Andrew Sullivan
Date:
Subject: Re: Trigger to convert UNIX time to timestamp without time zone.