Tom Lane wrote:
"Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> writes:
I remember that discussion, and I was for the change. However, upon
doing some testing after reading the above, I wonder if the
blank-stripping isn't too aggressive. I have a CHAR(6) field (say,
named Z) that ha
On 2005-10-21 20:23, Tom Lane wrote:
"Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> writes:
I remember that discussion, and I was for the change. However, upon
doing some testing after reading the above, I wonder if the
blank-stripping isn't too aggressive. I have a CHAR(6) field (sa
On Sat, 2005-10-22 at 00:39, Chris Travers wrote:
> Tom Lane wrote:
>
> >"Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> writes:
> >
> >
> >>I remember that discussion, and I was for the change. However, upon
> >>doing some testing after reading the above, I wonder if the
> >>blank-strip
quot; --
Steve Prefontaine
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe
Sent: Monday, October 24, 2005 9:46 AM
To: Chris Travers
Cc: Tom Lane; Dean Gibson (DB Administrator); pgsql-sql
Subject: Re: [SQL] Blank-padding
On Sat, 2005-10-22 at 00:39,
"Shaun Watts" <[EMAIL PROTECTED]> writes:
> Is there any way to eliminate the blank padding at the end of character
> fields in a table.
Use varchar, or text.
regards, tom lane
---(end of broadcast)---
TIP 5: don't forget to
On 2005-10-21 09:47, Tom Lane wrote:
Alex Turner <[EMAIL PROTECTED]> writes:
It appears that casting to a char() causes spaces to be stripped (ignored) from
the string:
mls=# select length('123 '::char(8));
length
3
(1 row)
I'm not sure about anyone else, but I would pers
"Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> writes:
> I remember that discussion, and I was for the change. However, upon
> doing some testing after reading the above, I wonder if the
> blank-stripping isn't too aggressive. I have a CHAR(6) field (say,
> named Z) that has "abc " in