Matt,
> I am have a query to perform aggregation functions on data retrieved from
> FB. This result differs when using GROUP BY. Query looks something like:
>
> 'select
> symbol,
> sum(price * vol)/sum(vol) as VWAP,
> sum(price) as SUMPRICE
>
> from Table1
> where symbol in('XYZ') GROUP BY symbol'
>
> The result(vwap and sumprice) I get for the above(single symbol) is different
> from when I use multiple symbols:
>
> 'where symbol in('XYZ', 'ABC') GROUP BY symbol'
>
> The above happens only for those symbols which has more ticks within the
> time range. Is this an issue of intermediate results on aggregate function?
> Please help.
This is a support issues which is not appropriate for discussion in this list
(intended for core engine development issues).
Please re-post your message* to the firebird-support mailing list @ Yahoogroups
(http://groups.yahoo.com/group/firebird-support/ )
Sean
* When you re-post some sample data/results would assist in answering your
question.
------------------------------------------------------------------------------
Want excitement?
Manually upgrade your production database.
When you want reliability, choose Perforce
Perforce version control. Predictably reliable.
http://pubads.g.doubleclick.net/gampad/clk?id=157508191&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
