No, because :
create view Test as
select st_article,extract(month from st_datelibre1) from statistiquefiche

Doesn't work !!!!

But "select st_article,extract(month from st_datelibre1) from
statistiquefiche" work fine.

Thank you for help...

Fabrice Vende
fabrice@...

-
SARL I N F O C O B
Developpement, formation, matériel, logiciel
http://www.infocob.com

----- Original Message -----
From: "Marcos Vinicius Dufloth" <dufloth@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, September 27, 2001 1:53 PM
Subject: Re: [ib-support] Group by month don't work !


> Try creating a view extracting month and then select the view grouping by
> month.
>
> -------------------------------------
> Marcos Vinicius Dufloth
> Tecnocyber, Ltda
> Erechim - RS - Brasil
> ICQ# 128291190
>
>
> ----- Original Message -----
> From: "Fabrice Vendé - INFOCOB" <fabrice@...>
> To: <ib-support@yahoogroups.com>
> Sent: Thursday, September 27, 2001 7:00 AM
> Subject: Re: [ib-support] Group by month don't work !
>
>
> Will a future version allow this ?
>
>
> Fabrice Vende
> fabrice@...
>
> -
> SARL I N F O C O B
> Developpement, formation, matériel, logiciel
> http://www.infocob.com
>
>
>
>
> >
> > Well, you could put it that way. InterBase doesn't let you group by an
> expression.
> >
> > Helen
> >
> > All for Open and Open for All
> > InterBase Developer Initiative · http://www.interbase2000.org
> > _______________________________________________________