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@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
