The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/datatype-character.html
Description:
removing trailing spaces on (implicit) cast from char to text can be
painful, and always surprising as shown in example with
SELECT 'a '::CHAR(2) collate "C" < E'a\n'::CHAR(2)
would it be worth mentioning a tip, that this behaviour can be monkey hacked
by concat(str "any" function that accepts char and returns text, thus
respecting the spaces, eg SELECT concat('a '::CHAR(2) collate "C") <
E'a\n'::CHAR(2) will return false as expected...
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs