Re: [GENERAL] Migration from DB2 to PostgreSQL-ROLLUP()

2013-06-19 Thread Merlin Moncure
On Wed, Jun 19, 2013 at 3:56 AM, sachin kotwal wrote: > While migrating my application from DB2 to PostgreSQL. > > I want to migrate ROLLUP() function in PostgreSQL. > > Example: > SELECT WEEK(SALES_DATE) AS WEEK, > DAYOFWEEK(SALES_DATE) AS DAY_WEEK, > SUM(SALES) AS UNITS_SOLD

Re: [GENERAL] Migration from DB2 to PostgreSQL-ROLLUP()

2013-06-19 Thread Pavel Stehule
Hello 2013/6/19 sachin kotwal : > While migrating my application from DB2 to PostgreSQL. > > I want to migrate ROLLUP() function in PostgreSQL. > > Example: > SELECT WEEK(SALES_DATE) AS WEEK, > DAYOFWEEK(SALES_DATE) AS DAY_WEEK, > SUM(SALES) AS UNITS_SOLD > FROM SALES > GRO

[GENERAL] Migration from DB2 to PostgreSQL-ROLLUP()

2013-06-19 Thread sachin kotwal
While migrating my application from DB2 to PostgreSQL. I want to migrate ROLLUP() function in PostgreSQL. Example: SELECT WEEK(SALES_DATE) AS WEEK, DAYOFWEEK(SALES_DATE) AS DAY_WEEK, SUM(SALES) AS UNITS_SOLD FROM SALES GROUP BY ROLLUP ( WEEK(SALES_DATE), DAYOFWEEK(SALES_