Re: character and text comparison

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jacek(at)szuwary(dot)org
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: character and text comparison
Date: 2004-09-15 16:43:11
Message-ID: 4720.1095266591@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Jacek Rembisz <jr178783(at)zodiac(dot)mimuw(dot)edu(dot)pl> writes:
> When I run SELECT ' '::character = ' '::text;
> on PostgreSQL 7.4 the result is `false'
> while on 7.3 and 7.2 instalations result is `true'

> Is this an intentional change?

Yes.

We now strip trailing blanks when converting a char(n) value to text.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruno Wolff III 2004-09-15 17:21:54 Re: BUG #1252: Optimization of SELECT for NOT NULL case
Previous Message Bender, Cheryl 2004-09-15 16:27:04 Re: Windows 8.0 beta on Server 2003 Installer problem