#!/bin/sh

if [ x"$1" = x"-i" ]
then
	echo "check for duplicate group names"
	exit 0
fi

echo "--- duplicate group names"

echo

psql -At << EOF
SELECT COUNT(*), group_name 
  FROM groups 
 WHERE status = 'A' 
 GROUP BY group_name 
HAVING COUNT(*) > 1
EOF

echo

exit 0

# eof
