Re: [GENERAL] Remove Duplicate Words from a field

[Sim Zacks]

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