behaviour of LENGTH() in postgresql v. 8 - Mailing list pgsql-novice

From Marcus Andree S. Magalhaes
Subject behaviour of LENGTH() in postgresql v. 8
Date
Msg-id 53754.201.12.65.196.1099087847.squirrel@201.12.65.196
Whole thread Raw
Responses Re: behaviour of LENGTH() in postgresql v. 8
Re: behaviour of LENGTH() in postgresql v. 8
List pgsql-novice
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.

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgresql crash- any ideas?
Next
From: Bruce Momjian
Date:
Subject: Re: behaviour of LENGTH() in postgresql v. 8