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(at)iol(dot)ie