Re: Remove Duplicate Words from a field

Sim Zacks <sim@xxxxxxxxxxxxxx> · Mon, 16 May 2011 15:54:17 +0300



    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ÂÂ