Re: DatabaseMetaData.getStringFunctions() reports "concat" - Mailing list pgsql-jdbc

From Werner Donné
Subject Re: DatabaseMetaData.getStringFunctions() reports "concat"
Date
Msg-id 03173809-F4A0-4BF0-99B1-F0107C928F14@pincette.biz
Whole thread Raw
In response to DatabaseMetaData.getStringFunctions() reports "concat"  (Werner Donné <werner.donne@pincette.biz>)
List pgsql-jdbc
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.


pgsql-jdbc by date:

Previous
From: Werner Donné
Date:
Subject: DatabaseMetaData.getStringFunctions() reports "concat"
Next
From: Werner Donné
Date:
Subject: Re: binary data