BUG #5092: to_ascii(); ascii() don't work with bytea

From: "Dan French" <Bomarc_com(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5092: to_ascii(); ascii() don't work with bytea
Date: 2009-10-02 02:17:14
Message-ID: 200910020217.n922HESW045278@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5092
Logged by: Dan French
Email address: Bomarc_com(at)yahoo(dot)com
PostgreSQL version: 8.4
Operating system: Windows 2003
Description: to_ascii(); ascii() don't work with bytea
Details:

Version 8.4
#1: bytea_string = '"0"' (table; bytea)
Function:
trim('"' both from bytea_string)
fails and returns: '"0'

#2: Come on folks: Bytea is a series of bytes. Conversion to ASCII is not
this difficult; and should (does) not require explicit type casts (esp since
they are already in ASCII)

SELECT ID, details_map,
--date_part('hour', interval
-- cast (
trim(both '"' from
to_ascii (
encode(convert_to(
{bytea starts here}
substring(...))...

Result (variations) include:
ERROR: function ascii(bytea) does not exist
ERROR: function convert_to(bytea) does not exist

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mike Pomraning 2009-10-02 05:05:34 BUG #5093: Prepared query gives different PGresult than exec'd equivalent
Previous Message mauro.infantino 2009-10-01 03:58:01 Re: BUG #5076: LEFT OUTER JOIN and WHERE madness