[BUGS] BUG #14800: substring produces different results with similar types

Поиск
Список
Период
Сортировка
От kostin.artem@gmail.com
Тема [BUGS] BUG #14800: substring produces different results with similar types
Дата
Msg-id 20170906132156.25639.91622@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: [BUGS] BUG #14800: substring produces different results withsimilar types  (Francisco Olarte <folarte@peoplecall.com>)
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      14800
Logged by:          Артём Костин
Email address:      kostin.artem@gmail.com
PostgreSQL version: 9.4.11
Operating system:   Win 10
Description:

These two commands produce different results with similar types
select substring(cast(' 2345           ' as character(16)), 1, 7) || '?',substring(cast(' 2345           ' as
varchar(16)),1, 7) || '?';
 

" 2345?";" 2345  ?"

Should it work in this way or not?


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: Marcin Gozdalik
Дата:
Сообщение: [BUGS] "Error could not open relation with OID ..." when selecting from pg_views
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [BUGS] Old row version in hot chain become visible after a freeze