Jacek Rembisz <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
