On Sun, 16 May 2004, David Teran wrote:
> i am using Postgres 7.4.2 with jdbc. Every time i try to select a
> varchar the SQL generated by the jdbc driver uses RTRIM(t0.columnname)
> which breaks an existing application. Is this normal, can we disable
> the RTRIM usage?
I assume from this bold claim that you have written an SQL query like
"SELECT t0.columnname FROM ..." and enabled statement logging in the
server and seen the executed query come through as "SELECT
RTRIM(t0.columnname) FROM ...". If this is the case then you are not
using the community supported jdbc driver because it never uses rtrim, and
you need to contact whoever wrote the jdbc driver you are using.
If you are having some unspecified problem with trailing spaces you need
to provide a description of your actual problem and ideally a test case
rather than jumping to conclusions about the JDBC driver and RTRIM.
Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
