subject:"\[SQL\] SUM Array values query"

Re: [SQL] SUM Array values query

2009-05-18 Thread Pawel Socha

2009/5/18 Dani Castaños : > Hi all, > > I've this query including arrays: > > SELECT hour[1:5], statistics_date > FROM statistics_daily > WHERE statistics_date = to_date( '03/01/2008', 'DD/MM/' ) > > Result: > > hour | statistics_date > +-

[SQL] SUM Array values query

2009-05-18 Thread Dani Castaños

Hi all, I've this query including arrays: SELECT hour[1:5], statistics_date FROM statistics_daily WHERE statistics_date = to_date( '03/01/2008', 'DD/MM/' ) Result: hour| statistics_date +- {1800,1800,1800,1800,1800} | 2