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

[Neumann, Andreas]

Hi Jürgen, 

I can follow your examples - they work fine. 

My conclusion is that the expressions are fine - but there is an issue
if the attribute data that comes from Postgis with a data type
"timestamp without time zone". Maybe these attribute columns from
Postgis aren't correctly evaluated as a DateTime data type? 

------------------ 

I'll send you some sample data privately. 

Thanks, 

Andreas 

On 2015-11-17 21:29, Jürgen E. Fischer wrote: 

> Hi Andreas,
> 
> On Tue, 17. Nov 2015 at 19:24:20 +0100, Neumann, Andreas wrote: 
> 
>> 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.
> 
> Oh, I completely missed that you were talking about an expression. Sorry.
> 
> But I cannot reproduce the problem with an expression either:
> 
> to_datetime('2015-11-17T21:24:18') <= to_datetime('2015-11-17T21:24:18') AND to_datetime('2015-11-17T21:24:18') >= to_datetime('2015-11-17T21:24:18')
> 
> produces 1 too.
> 
> 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/20151118/5d472644/attachment.html>