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: [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
