Hi Andreas, On Mon, 21. Sep 2015 at 08:39:19 +0200, Andreas Neumann wrote: > So how is concat(NULL,fieldname) any better than > COALESCE(fieldname,'').
That was just to illustrate the difference between foo||bar and concat(foo,bar). concat handles NULL as empty string (like in postgres) while || returns NULL if either operand is NULL. Jürgen -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-31 Dipl.-Inf. (FH) Rheinstraße 13 Fax. +49-4931-918175-50 Software Engineer D-26506 Norden http://www.norbit.de QGIS release manager (PSC) Germany IRC: jef on FreeNode
signature.asc
Description: Digital signature
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
