Changes between Version 12 and Version 13 of v6/pgsummary

Timestamp:

05/03/2012 10:36:14 AM (14 years ago)

Author:

huangzhong

Comment:

--

v6/pgsummary

@@ -72 +72 @@
 )
 SELECT * FROM source;
+}}}
+* wm_concat写法调整
+{{{
+oracle(默认的连接符为逗号):
+select wm_concat (distinct area_id) from pp_ad group by brand_id ;
+
+pg:
+select STRING_AGG (company_name, ',') from pp_ad group by brand_id ;
+select STRING_AGG (distinct area_id::text, ',') from pp_ad group by brand_id ;
 }}}