But documentation says different. So this behaviour is unxpected.
6 сент. 2017 г. 5:51 PM пользователь "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> написал:
> Francisco Olarte <folarte(at)peoplecall(dot)com> writes:
> > Anyway, you may notice char() discards trailing blanks, varchar does not:
>
> More precisely, converting from char(n) to varchar or text discards
> trailing blanks. Since both substring() and the || operator take
> text argument types, an implicit coercion to text is happening in
> these examples ... and that's where the blanks went.
>
> regards, tom lane
>