Hello,

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?

regards,
Jacek Rembisz





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

Jacek Rembisz <jr178783 (AT) zodiac (DOT) mimuw.edu.pl> writes:
Yes.

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

regards, tom lane

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

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

On Wed, Sep 15, 2004 at 12:43:11PM -0400, Tom Lane wrote:
Thank you for a quick answer.

I have changed my application to use text type instead of character type.

best regards,
Jacek Rembisz

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly