Thread: DatabaseMetaData.getStringFunctions() reports "concat"

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.

I'm sorry. I made a mistake. The call to "concat" is properly translated to the "||" operator.
My apologies.

Werner.

On 07 Dec 2010, at 14:40, Werner Donné wrote:

> Hello,
>
> I use PostGreSQL 9.0.1 with the JDBC-driver 9.0-801. The method java.sql.DatabaseMetaData.getStringFunctions()
reportsthe following: 
>
> "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.
>

--
http://www.pincette.biz/
Handling your documents with care, wherever you are.