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.