Added to TODO:
Make LENGTH() of CHAR() not count trailing spaces
---
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Well, that certainly is interesting. Oracle and MS-SQL preserve the
> > trailing
Troels Arvin <[EMAIL PROTECTED]> writes:
> Why not just change the behaviour back to what it used to be like? I see
> no justification for the change:
Well, for one thing, it makes the behavior of comparisons compatible
with the SQL standard. If we have unpleasant side-effects we can work
on thos
On Thu, 20 Nov 2003 12:40:30 -0500, Tom Lane wrote:
> AFAICS the Oracle and SQL Server behaviors are at least as inconsistent
> as our own.
> If trailing spaces are significant during concatenation,
> why aren't they significant to LENGTH()?
Oracle _does_ count the trailing spaces in it's LENGTH
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Well, that certainly is interesting. Oracle and MS-SQL preserve the
> trailing space when concatenating. Does anyone remember the logic for
> trimming space with ||?
"trimming space with ||" is a completely inaccurate description of
what's happening.
Well, that certainly is interesting. Oracle and MS-SQL preserve the
trailing space when concatenating. Does anyone remember the logic for
trimming space with ||?
---
William ZHANG wrote:
>
> Bruce said:
> > How do other d
