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

From Marcus Andree S. Magalhaes
Subject Re: behaviour of LENGTH() in postgresql v. 8
Date
Msg-id 53800.201.12.65.196.1099089672.squirrel@201.12.65.196
Whole thread Raw
In response to Re: behaviour of LENGTH() in postgresql v. 8  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice

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

<snip>
> 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.
<snip>

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: behaviour of LENGTH() in postgresql v. 8
Next
From: Terry Lee Tucker
Date:
Subject: Array Question