I am looking to remove duplicates for a string field.
For example the field uses someones unique logon name and I want to give everyone a unique login.
The only way I thought of doing this was to use a function, but that means I need to install the language etc.
For duplicates I would just like to append a unique ID :
eg
Bill
Bill1
Bill2
...
Without the use of a cursor, I could not see a way around it. I am familiar with Oracle and SQL Server, but I cannot seem to find an equivlent of their procedures in postgres.
Thanks
For example the field uses someones unique logon name and I want to give everyone a unique login.
The only way I thought of doing this was to use a function, but that means I need to install the language etc.
For duplicates I would just like to append a unique ID :
eg
Bill
Bill1
Bill2
...
Without the use of a cursor, I could not see a way around it. I am familiar with Oracle and SQL Server, but I cannot seem to find an equivlent of their procedures in postgres.
Thanks