Re: BUG #1947: Enhancement Request - CONCAT() function

Tom Lane wrote:

>"Jim C. Nasby" <jnasby@pervasive.com> writes:
>
>
>>And you might want to make it a project at http://pgfoundry.org so
>>others can make use of it. You might also want to define it as accepting
>>an array; I think that would allow you to accept any number of
>>parameters.
>>
>>
>
>I think Tony is trying to avoid putting in any actual work ;-).
>
And that he wants to write queries that work on Oracle, MySQL, and
PostgreSQL at the same time.

One point I would make is that although || might appear to break MySQL
at the moment, you can set the operator to be concat for the application
(maybe in the function that connects to the DB?)
Best Wishes
Chris Travers
Metatron Technology Consulting