Search Postgresql Archives
cast bytea to text
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: pgsql-general@xxxxxxxxxxxxxx
- Subject: cast bytea to text
- From: "Willy-Bas Loos" <willybas@xxxxxxxxx>
- Date: Thu, 1 Mar 2007 14:15:49 +0100
- Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=J/iGY7DZshnfdWt9ze3eu/1yyRhrPVtPjT3aspc7dgcZXbkoYnxQvW/7FeTIvCnwR1Nqf1zDz7de/dFOlANR2LR+9ld4iALskwuCNWkXvWo29HEZJzKbhGn+4WN9kiGSNJu/ChSEOCuHhkmDOyoDR/Es0rUrNBK5YmFyBF+KGx0=
Dear List,
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
SQL state: 42883
Hint: No function matches the given name and argument types. You may need to add explicit type casts.
Context: SQL function "bytea2text"
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]