Re: cast bytea to text
| От | Willy-Bas Loos |
|---|---|
| Тема | Re: cast bytea to text |
| Дата | |
| Msg-id | 1dd6057e0703010942w176e34a9sa362c68e1198343a@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: cast bytea to text ("Albe Laurenz" <all@adv.magwien.gv.at>) |
| Список | pgsql-general |
yep, sry it took me a while to answer. It works now.
here´s my code:
-- start code --
create or replace function bytea2text(bytea) returns text as
$$
select ENCODE($1, 'escape');
$$
language sql strict;
create cast (bytea as text)
with function bytea2text(bytea)
as implicit;
-- end code --
thanks!
Willy-Bas Loos
here´s my code:
-- start code --
create or replace function bytea2text(bytea) returns text as
$$
select ENCODE($1, 'escape');
$$
language sql strict;
create cast (bytea as text)
with function bytea2text(bytea)
as implicit;
-- end code --
thanks!
Willy-Bas Loos
On 3/1/07, Albe Laurenz <all@adv.magwien.gv.at> wrote:
> How can i cast bytea to text?
> I´ve read about the DECODE function, but my 8.1 backend
> doesn´t recognize it.
> I´m trying to create an implicit cast using the function:
>
> create or replace function bytea2text(bytea) returns text as
> $$
> select DECODE($1, 'escape');
> $$
> language sql strict;
>
> Answer:
> ERROR: function decode(bytea, "unknown") does not exist
Try ENCODE instead of DECODE ...
Yours,
Laurenz Albe
В списке pgsql-general по дате отправления: