I would use a plpython or plperl function
In python you can split the word into a list and then get unique items and put it back in a string, for example.
Sim
On 05/16/2011 03:34 PM, Sukuchha Shrestha wrote:
Dear All,
I am new to Postgresql. I have a field with lots of dublicate words and i want to remove any dublicate word from that field.
For example, if i have a field with a string " one, one, two, two, three", how would i get " one, two, three" only ?
Any help is much apprecieated !
Sukuchha