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 ?
Maybe a regular expression, using regexp_replace()? http://www.postgresql.org/docs/8.4/static/functions-string.html Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
