The following bug has been logged online: Bug reference: 5092 Logged by: Dan French Email address: bomarc_...@yahoo.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs