[Qgis-user] Issue with temporal query in a symbology rule

[Neumann, Andreas]

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>