On Fri, Sep 16, 2005 at 12:00:59PM -0400, Bruce Momjian wrote:
> Jim(dot)Gray(at)Bull(dot)com wrote:
> > What do you think of an Postgres option that would enable stripping of
> > trailing blanks from connect host variables when turned ON?
> I would not support such an option. If we added flags for every single
> thing that someone wanted, the system would be unusable.
> Just because Oracle does it doesn't mean we should.
Does Oracle really munge data on the client side? Or does it, like
PostgreSQL, pass the host variable's value as-is to the server, and
the server considers trailing spaces significant or not depending
on the context? Is it the client-side behavior or the server-side
behavior that's different between PostgreSQL and Oracle?
If Oracle strips trailing spaces on the client side, is that a
configurable option? How would you insert significant trailing
spaces into a VARCHAR column if the client library strips them?
In response to
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2005-09-16 19:39:38|
|Subject: Re: BUG #1871: operations with data types|
|Previous:||From: Bruce Momjian||Date: 2005-09-16 16:00:59|
|Subject: Re: BUG #1862: ECPG Connect, host variable trailing blanks|