Home > mailing lists

Re: I need to find all of the unique characters within a text field - Mailing list pgsql-admin

From	nw@hydaspes.if.org
Subject	Re: I need to find all of the unique characters within a text field
Date	November 9, 2009 21:24:04
Msg-id	49708.66.227.17.7.1257805012.squirrel@granicus.if.org Whole thread Raw
In response to	I need to find all of the unique characters within a text field ("Campbell, Lance" <lance@illinois.edu>)
List	pgsql-admin

> How do I identify all of the unique characters within a text field?

select distinct regexp_split_to_table('hello world', E'');

--
nathan wagner

From: "Campbell, Lance"
Date: 09 November 2009, 20:27:56
Subject: I need to find all of the unique characters within a text field

From: "Campbell, Lance"
Date: 10 November 2009, 14:22:53
Subject: 8.4 auto vacuum