On Fri, Sep 16, 2005 at 12:00:59PM -0400, Bruce Momjian wrote:
> Jim.Gray@Bull.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.
[snip]
> 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?
--
Michael Fuhr