> -----Original Message-----
> From: Kevin Grittner [mailto:[EMAIL PROTECTED]
> Sent: 10 October 2005 15:50
> To: [EMAIL PROTECTED]; pgsql-bugs@postgresql.org
> Subject: Re: [BUGS] BUG #1947: Enhancement Request - CONCAT() function
>
>
> If you are striving for portability, perhaps you are using
> Java as your programming language.
Nice try, but I don't use Java. I'm a COBOL man myself :)
Actually, I am currently developing software with PHP that I don't want tied
to a single DBMS, which is my I am looking for portability between MySQL,
PostgreSQL and Oracle.
> If so, you could benefit
> from the fact that the volunteers in the PostgreSQL community
> have put the effort into the JDBC driver to support the
> escape sequence for portable string concatenation. This
> works in PostgreSQL:
>
> select {fn CONCAT(field1, ' ', field2)}
>
> However, for maximum portability, you should probably use:
>
> select {fn CONCAT({fn CONCAT(field1, ' ')}, field2)}
>
> Using more than two parameters does not work in the JDBC
> driver for at least one commercial DBMS product. (I found
> one where there is no exception thrown for the additional
> parameters; they are silently
> discarded.)
>
> -Kevin
>
> P.S. A more professional and cooperative tone in any future
> posts would be appreciated.
I will try.
Tony Marston
http://www.tonymarston.net
> >>> "Tony Marston" <[EMAIL PROTECTED]> 10/08/05
> 6:39 AM >>>
>
> I would like the option to use CONCAT(field1, ' ', field2)
> instead of the vertical bar syntax (field1 || ' ' || field2)
> as this is also available in other popular databases (MySQL,
> ORACLE). I am trying to develop applications which are
> daabase independent, so the use of common SQL syntax is very
> important.
>
>
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
