update_tables_0.2.x-0.3.pgsql
changeset 0 bb0aa2102206
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/update_tables_0.2.x-0.3.pgsql	Sun Jan 06 18:22:10 2008 +0000
@@ -0,0 +1,8 @@
+-- $Id$
+
+DROP VIEW ma_aliases_count;
+CREATE OR REPLACE VIEW vmm_alias_count AS
+    SELECT count(DISTINCT address) AS aliases, gid
+      FROM alias
+  GROUP BY gid;
+