Remove Duplicate Words from a field

From: Sukuchha Shrestha <sukuchha(at)yahoo(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Remove Duplicate Words from a field
Date: 2011-05-16 12:34:09
Message-ID: 348628.24982.qm@web29107.mail.ird.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2011-05-16 12:44:00 Re: Remove Duplicate Words from a field
Previous Message Nick Raj 2011-05-16 11:13:53 arguments are not toastable