Moin Uwe, On Fri, 04. Nov 2022 at 13:59:35 +0100, Uwe Fischer wrote: > great - it works as expected!! Thank you! > How can I find out about the engine that is used and the SQL syntax for > virtual layers? I'd like to learn about it to be able to build more queries > like this one.
Well, || is the standard syntax, but there are probably also databases that will take + to concatenate strings too. It's SQLite: https://docs.qgis.org/3.28/en/docs/user_manual/managing_data_source/create_layers.html#supported-query-language 14.2.5.2. Supported query language The underlying engine uses SQLite and SpatiaLite to operate. 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 https://www.norbit.de QGIS release manager (PSC) Germany IRC: jef on Libera|OFTC
signature.asc
Description: PGP signature
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user