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