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

Поиск
Список
Период
Сортировка
От Dan French
Тема BUG #5092: to_ascii(); ascii() don't work with bytea
Дата
Msg-id 200910020217.n922HESW045278@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5092: to_ascii(); ascii() don't work with bytea  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      5092
Logged by:          Dan French
Email address:      Bomarc_com@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

В списке pgsql-bugs по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Re: BUG #5076: LEFT OUTER JOIN and WHERE madness
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: BUG #5092: to_ascii(); ascii() don't work with bytea