[Qgis-user] Concatenate address fields with NULLS

[Jürgen E. Fischer]

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                         
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 827 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150921/3fac6f10/attachment.sig>