Hi Bernhard,
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.
Andreas
On 21.09.2015 13:11, Bernd Vogelgesang wrote:
Am 21.09.2015, 08:39 Uhr, schrieb Andreas Neumann <[email protected]>:
... if you use capital letters in field names (which is discourage
anyway).
Hi Andreas,
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.
(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.)
Cheers
Bernd
On 20.09.2015 12:59, Matthias Kuhn wrote:
Hi Phil,
In addition to COALESCE I'd like to promote the use of the
function *CONCAT()* which treats NULL values as empty strings (it
was changed recently, it's probably since 2.10) what makes it
very handy.
Example:
NULL || "hello" -> NULL
vs.
CONCAT( NULL , "hello") -> "hello
vs.
COALESCE( NULL, "" ) || "hello" -> "hello"
Cheers,
Matthias
On 09/20/2015 09:54 AM, Phil (The Geek) Wyatt wrote:
Hi Folks,
I am working with LIST Address Points data from
http://listdata.thelist.tas.gov.au/opendata/ (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.
Can someone give me a quick heads up on how to NOT add the data
from a field that has NULL?
Chances are I will be doing this regularly so I am keen to
document the required expressions for others to use as well.
Cheers - Phil
Volunteer Mapper - Red Cross
<http://www.redcross.org.au/volunteering.aspx>
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
--
Bernd Vogelgesang
Siedlerstraße 2
91083 Baiersdorf/Igelsdorf
Tel: 09133-825374
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
