trailing - Search results

Mailing lists  >>  pgsql-novice  >>  Thread

2018-01-17 06:32:05 | Re: why do i get 2 as answer for select length('aa '::char(6)); (Tom Lane)

trailing spaces to be significant. To my mind, there are very few situations where char

Mailing lists  >>  pgsql-novice  >>  Thread

2018-01-17 06:23:13 | Re: why do i get 2 as answer for select length('aa '::char(6)); (john snow)

trailing spaces in char-type values, and i don't understand why it's inconsistent

Mailing lists  >>  pgsql-novice  >>  Thread

2018-01-17 06:09:16 | Re: why do i get 2 as answer for select length('aa '::char(6)); (Tom Lane)

trailing spaces in char-type values, on the theory that they're semantically insignificant. regards

Mailing lists  >>  pgsql-novice  >>  Thread

2018-01-17 05:52:23 | Re: why do i get 2 as answer for select length('aa '::char(6)); (David G. Johnston)

trailing spaces are treated as semantically insignificant and disregarded when comparing two values of type