Rename entries with an increment

Hi, here is my issue. I have a table containing names. If a name appears
several times, I would like to rename it to add an incremented number to it.
For example, if 'Peter' appears three times in the table, I would like to
rename the first 'Peter' entry to 'Peter-1', the second one to 'Peter-2' and
so on. However, I began to do something but this doesn't seem to work at all
^^. Could someone please help me ? Thanks :)

DECLARE num int;

UPDATE test.suscribers
SET p_name = CONCAT(p_name,'-',num)
WHERE p_name=
(
SELECT name
FROM
(
SELECT *
FROM
(
SELECT test.suscribers.p_name AS nom, COUNT(*) AS nb
FROM test.suscribers
GROUP BY test.suscribers.p_name
)
AS table1
WHERE nb>1 AND wagaa != ''
)
AS table2
)

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Rename-entries-with-an-increment-tp5821237.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.