At 16:21 20/01/2004 -0300, you wrote:

>Hi,
>
>The bug <#546274 group by EXTRACT function doesn't work> appear as closed and
>fixed but at changes history at the end of tracker's detailed view page appear
>as opened and with resolution id as none.
>What's the real state of this bug? I'm asking because i can't test with RC8
>right now and with RC7 the bug still exists.
>
>Valdir.

Hi Valdir,

I have just tried

select
sum(cmp_total), extract(year from emissao), extract(month from emissao)
from
NotaFiscal
group by
extract(year from emissao), extract(month from emissao)
order by
2, 3

Appears to work fine, no errors, but I do not check if the values are correct.

What errors do you get ?

Sintax or wrong values ?



Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.564 / Virus Database: 356 - Release Date: 19/01/2004


[Non-text portions of this message have been removed]