"Marc G. Fournier" <scrappy@xxxxxxxxxxxxxx> writes:
> On Wed, 19 Oct 2005, Richard_D_Levine@xxxxxxxxxxxx wrote:
>
>> I was referring to trailing blanks, but did not explicitly say it,
>> though showed it in the examples. I am pretty sure that the SQL
>> standard says that trailing whitespace is insignificant in string
>> comparison.
>
> Then we are broken too :)
>
> # select 'a ' = 'a ';
> ?column?
> ----------
> f
> (1 row)
# select 'a'::char(8) = 'a '::char(8);
?column?
----------
t
(1 row)
Trailing blanks aren't significant in fixed-length strings, so the
question is whether Postgresql treats comparison of varchars right.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
