I need to find all of the unique characters within a text field

От:

"Campbell, Lance" <lance@illinois.edu>

Дата:

9 ноября 2009 г. в 17:27:56

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

Thanks,

Lance Campbell
Project Manager/Software Architect/DBA
Web Services at Public Affairs
217-333-0382

От:

nw@hydaspes.if.org

Дата:

9 ноября 2009 г. в 18:24:04

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

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

-- 
nathan wagner