<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hi Bernhard,<br>
<br>
This is provider dependent. In PostgreSQL you will have to double
quotes around the field names if they contain upper case letters or
special characters not valid in SQL object names. QGIS stays on the
"safe" side and will always add double quotes around the fields,
even if it isn't strictly required.<br>
<br>
Andreas<br>
<br>
<div class="moz-cite-prefix">On 21.09.2015 13:11, Bernd Vogelgesang
wrote:<br>
</div>
<blockquote cite="mid:op.x5a717mhl2i25i@bernd-terra-pc" type="cite">
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
<style type="text/css">body { font-family:'DejaVu Sans Mono'; font-size:12px}</style>
Am 21.09.2015, 08:39 Uhr, schrieb Andreas Neumann
<a class="moz-txt-link-rfc2396E" href="mailto:a.neumann@carto.net"><a.neumann@carto.net></a>:<br>
<br>
<blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px
solid; padding-left: 1ex">... if you use capital letters in
field names (which is discourage anyway).</blockquote>
<div>Hi Andreas,</div>
<div>could you elaborate a little on why not to use capital
letters for field names? Recently I started using capital
letters for fields, cause for me, any expressions and codes
becomes much better readable.</div>
<div>(Which also reminds me, that a lot of processing functions
change field names to upper case or lower case or leave them as
is, totally unconsistenly.)</div>
<div><br>
</div>
<div>Cheers</div>
<div>Bernd</div>
<div><br>
</div>
<blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px
solid; padding-left: 1ex"><br>
<br>
<br>
<div class="moz-cite-prefix">On 20.09.2015 12:59, Matthias Kuhn
wrote:<br>
</div>
<blockquote cite="mid:55FE9175.6040706@opengis.ch" type="cite">
Hi Phil,<br>
<br>
In addition to COALESCE I'd like to promote the use of the
function <b>CONCAT()</b> which treats NULL values as empty
strings (it was changed recently, it's probably since 2.10)
what makes it very handy.<br>
<br>
Example:<br>
<br>
NULL || "hello" -> NULL<br>
<br>
vs.<br>
<br>
CONCAT( NULL , "hello") -> "hello<br>
<br>
vs.<br>
<br>
COALESCE( NULL, "" ) || "hello" -> "hello"<br>
<br>
Cheers,<br>
Matthias<br>
<br>
<div class="moz-cite-prefix">On 09/20/2015 09:54 AM, Phil (The
Geek) Wyatt wrote:<br>
</div>
<blockquote
cite="mid:005301d0f379$8ca06a60$a5e13f20$@wyatt-family.com"
type="cite">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
<div class="WordSection1">
<p class="MsoNormal">Hi Folks,</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am working with LIST Address Points
data from <a moz-do-not-send="true"
class="moz-txt-link-freetext"
href="http://listdata.thelist.tas.gov.au/opendata/">http://listdata.thelist.tas.gov.au/opendata/</a>
(Specifically Clarence Municipality) and I need to
concatenate into one field the full address of each
location. I am struggling to figure out how to do it
when there are fields for unit numbers, building names,
numbers to and from etc. Many of the fields are also
NULL so clearly I want those fields disregarded.</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Can someone give me a quick heads up
on how to NOT add the data from a field that has NULL?</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Chances are I will be doing this
regularly so I am keen to document the required
expressions for others to use as well.</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span
style="mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="mso-fareast-language:EN-AU">Cheers - Phil</span></p>
<p class="MsoNormal"><span
style="mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="mso-fareast-language:EN-AU">Volunteer Mapper -
<a moz-do-not-send="true"
href="http://www.redcross.org.au/volunteering.aspx"><span
style="color:windowtext;text-decoration:none">Red
Cross</span></a></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
<br>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
</blockquote>
<br>
<br>
<br>
<div id="M2Signature">
<div>-- </div>
<div>Bernd Vogelgesang<br>
Siedlerstraße 2<br>
91083 Baiersdorf/Igelsdorf<br>
Tel: 09133-825374</div>
</div>
</blockquote>
<br>
</body>
</html>