On Wed, Sep 15, 2004 at 12:43:11PM -0400, Tom Lane wrote:
> 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
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.
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 forge
