Must appear in GROUP BY error

[djelebovk]

Hi guys,

I have this simple query:

SELECT date_trunc('day', purchase_date), COUNT(*) FROM purchases GROUP BY date_trunc('day', purchase_date);[/code]

When I want to parametrize the query:

SELECT date_trunc($P{period}, purchase_date), COUNT(*)FROM purchases GROUP BY date_trunc($P{period}, purchase_date);[/code]

I am getting this error: ".... purchases.purchase date must appear in GROUP BY ... " both on jasper server 5.2.0 and on iReport Studio 5.6.0

First I've thought that the issue is with the driver. I've updated it and now I am using the latest one: "postgresql-9.4.1207"... again I get the same error. Then I've tested the driver by writting a tiny java program that does the same and it worked.

Thanks in advance, Kosta

P.S.

The example query is simple but the one I want to have in production is quite complex and I don't find a meaningful way to work around the use of such GROUP BY statement.

P.S.2

OMG I hate this editor