Dear all,

While checking the last Beta3-Beta4 Changelog of Postgres 8.0,
I saw the following:

* doc/TODO: Remove completed items:
<snip>
* -Make LENGTH() of
CHAR() not count trailing spaces

If I understand correctly, this will lead to the following situation:

CHAR_LENGTH('ABCD') == CHAR_LENGTH('ABCD ') == 4

This will definitely break some of our applications.

Just want to be sure if this LENGTH() behaviour _will_ appear
on the next version of Postgres. If true, can we somehow revert
to the current LENGTH() behaviour?

Can someone, please, clarify this issue?

Thanks a lot.

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Marcus Andree S. Magalhaes wrote:
You should review the release notes. The full description is:

* Make length() disregard trailing spaces in CHAR(n) (Gavin)
This change was made to improve consistency: trailing spaces
are semantically insignificant in CHAR(n) data, so
they should not be counted by length().

--
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

"Marcus Andree S. Magalhaes" <marcus.magalhaes (AT) vlinfo (DOT) com.br> writes:
If you think trailing spaces are semantically significant, you should be
using varchar or text fields to store them. In CHAR(n) fields they are
not significant, and we're doing our best to make that interpretation
consistent across all operations.

Just for the record, I get this with CVS tip:

regression=# select CHAR_LENGTH('ABCD ');
char_length
-------------
8
(1 row)

regression=# select CHAR_LENGTH('ABCD '::text);
char_length
-------------
8
(1 row)

regression=# select CHAR_LENGTH('ABCD '::varchar);
char_length
-------------
8
(1 row)

regression=# select CHAR_LENGTH('ABCD '::char(8));
char_length
-------------
4
(1 row)

(the first and second cases are in fact the same)

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Thanks for your answer. We're already using text and varchar, so we
should be safe when we migrate our server.

<snip>

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings