[Qgis-user] Issue with temporal query in a symbology rule
Neumann, Andreas
a.neumann at carto.net
Tue Nov 17 10:24:20 PST 2015
Hi Jürgen,
Thanks for your reply.
I know that it works well on PostgreSQL - but I am talking about
symbology rules in QGIS. Can I use Postgis syntax in QGIS rules? The
QGIS query builder doesn't list "BETWEEN" as an operator.
Andreas
On 2015-11-17 18:17, Jürgen E. Fischer wrote:
> Hi Andreas,
>
> On Tue, 17. Nov 2015 at 17:01:31 +0100, Neumann, Andreas wrote:
>
>> hm - I found out that my query
>>
>> start_time <= now() AND end_time >= now()
>
> I'd do: now() BETWEEN start_time AND end_time
>
>> works fine if start_time, now() and end_time are on three different
>> dates, but it fails if all are on the same day. Very strange. Anyone
>> knows what's wrong?
>
> Strange, as
>
> select '2015-11-17 18:13:11.144695+01'::timestamp <= '2015-11-17 18:13:11.144695+01'::timestamp AND '2015-11-17 18:13:11.144695+01'::timestamp >= '2015-11-17 18:13:11.144695+01'::timestamp;
>
> produces "t" here on
>
> version
> ----------------------------------------------------------------------------------------------
> PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit
>
> Jürgen
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20151117/f21a4057/attachment.html>
More information about the Qgis-user
mailing list