Hello,
I use PostGreSQL 9.0.1 with the JDBC-driver 9.0-801. The method java.sql.DatabaseMetaData.getStringFunctions() reports
thefollowing:
"ascii,char,concat,lcase,left,length,ltrim,repeat,rtrim,space,substring,ucase,replace"
This contains the "concat" function, which is not allowed in the SQL-syntax.
Best regards,
Werner.
--
http://www.pincette.biz/
Handling your documents with care, wherever you are.