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

[Brigitte Duplenne]

Hi Maxime,

You are probably using ',' for decimal separator.
In that case you to have a space before and after the comma.
"... order by 1,2" will indeed not compile but "... Order by 1 , 2" will
compile.

Brigitte
 

-----Original Message-----
From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Maxime Richez
Sent: vendredi 3 novembre 2006 01:00
To: openroad-users at peerlessit.com
Subject: [Openroad-users] Group by date_trunc(...) in Openroad

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 

_______________________________________________
Openroad-users mailing list
Openroad-users at peerlessit.com
http://peerlessit.com/mailman/listinfo/openroad-users