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@marston-home.demon.co.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@fetter.org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!