Re: [GENERAL] Remove Duplicate Words from a field

2011-05-16 Thread Pavel Stehule
om being a dead man. > Sukuchha nice to help you :) Regards Pavel > > Von: Pavel Stehule > An: Sukuchha Shrestha > CC: pgsql-general@postgresql.org > Gesendet: Montag, den 16. Mai 2011, 15:06:14 Uhr > Betreff: Re: [GENERAL] Remove Du

Re: [GENERAL] Remove Duplicate Words from a field

2011-05-16 Thread Sukuchha Shrestha
Von: Pavel Stehule An: Sukuchha Shrestha CC: pgsql-general@postgresql.org Gesendet: Montag, den 16. Mai 2011, 15:06:14 Uhr Betreff: Re: [GENERAL] Remove Duplicate Words from a field Hello 2011/5/16 Sukuchha Shrestha : > Dear All, > I am new to Postgresql. I have a field wit

Re: [GENERAL] Remove Duplicate Words from a field

2011-05-16 Thread Pavel Stehule
Hello 2011/5/16 Sukuchha Shrestha : > 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 ?

Re: [GENERAL] Remove Duplicate Words from a field

2011-05-16 Thread 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

Re: [GENERAL] Remove Duplicate Words from a field

2011-05-16 Thread Raymond O'Donnell
On 16/05/2011 13:34, 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