[Openroad-users] Group by date_trunc(...) in Openroad

[Maxime Richez]

Hi everybody,
 
Here's my little problem with Openroad 4.1 and sql (ingres)
 
procedure example=
begin
   select date_trunc('day',date_mvt) as :date_mvt,
             item as :item,
             sum(quantity) as :qty
   from sales
   group by date_mvt,item 
   order by 1,2
end;
 
 
How to use the group by with "date_trunc('day',date_mvt)" 
 
I can't use "group by 1,2" neither "group by date_trunc('day',date_mvt)"
 
Openroad -> E_W400F0 Syntax error.  The last symbol read was '1'
 
Thanks for your help ! 
 
Maxime Richez
Saluc SA - Belgium