On Fri, Sep 16, 2005 at 12:00:59PM -0400, Bruce Momjian wrote: > [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings