1 -- $Id$

     2 

     3 DROP VIEW ma_aliases_count;

     4 CREATE OR REPLACE VIEW vmm_alias_count AS

     5     SELECT count(DISTINCT address) AS aliases, gid

     6       FROM alias

     7   GROUP BY gid;

     8