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

This is a multi-part message in MIME format.

------_=_NextPart_001_01CA6181.9A35E6E2
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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


------_=_NextPart_001_01CA6181.9A35E6E2
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7654.12">
<TITLE>I need to find all of the unique characters within a text =
field</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->

<P><FONT SIZE=3D2 FACE=3D"Arial">How do I identify all of the unique =
characters within a text field?</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks,</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Lance Campbell</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Project Manager/Software =
Architect/DBA</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Web Services at Public Affairs</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">217-333-0382</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01CA6181.9A35E6E2--
Lance [ Mo, 09 November 2009 22:14 ] [ ID #2022176 ]

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

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

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

--
nathan wagner



--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Nathan Wagner [ Mo, 09 November 2009 23:16 ] [ ID #2022177 ]
Datenbanken » gmane.comp.db.postgresql.admin » I need to find all of the unique characters within a text field

Vorheriges Thema: 8.4 auto vacuum
Nächstes Thema: configuration kerberos in Postgre sql