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
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 |