Re: BUG #1947: Enhancement Request - CONCAT() function - Mailing list pgsql-bugs

From Chris Travers
Subject Re: BUG #1947: Enhancement Request - CONCAT() function
Date
Msg-id 4357CEC6.8070408@travelamericas.com
Whole thread Raw
In response to Re: BUG #1947: Enhancement Request - CONCAT() function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: SIGSEGV in Postgres 8.0.3 (libpq4)
Next
From: Chris Travers
Date:
Subject: Re: BUG #1947: Enhancement Request - CONCAT() function