-- @author tungs1
-- @modified 2013-07-28 12:00:00
-- @created 2013-07-28 12:00:00
-- @description groupingfunction groupingfunc173.sql
-- @db_name groupingfunction
-- @executemode normal
-- @tags groupingfunction
-- order 1
select 'a', * from ((SELECT GROUPING(product.pname) as g1 FROM product, sale WHERE product.pn=sale.pn GROUP BY GROUPING SETS (sale.pn, product.pname) ORDER BY g1) UNION (SELECT sale.pn FROM sale)) as a;
 ?column? | g1  
----------+-----
 a        | 200
 a        | 300
 a        | 100
 a        | 500
 a        | 700
 a        |   0
 a        |   1
 a        | 400
 a        | 600
 a        | 800
(10 rows)