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

On Sat, Oct 08, 2005 at 12:39:40PM +0100, Tony Marston wrote:
>
> The following bug has been logged online:
>
> Bug reference: 1947
> Logged by: Tony Marston
> Email address: tony(at)marston-home(dot)demon(dot)co(dot)uk
> PostgreSQL version: 8.0.3
> Operating system: Windows XP
> Description: Enhancement Request - CONCAT() function
> Details:
>
> 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.

Fix your application so that it uses the SQL standard ||, which Oracle
supports and MySQL can be made to support via a runtime option.

Also, before deciding that you must support multiple back-end
databases, please look over this presentation

http://www.powerpostgresql.com/Downloads/database_depends_public.swf

and see whether this is really a road you want to travel.

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!