Tim Johnson writes:
> Hi,
>
> I have postgres 6.x (where x is something).
>
> I have the following list of data
>
> data
> --------
> ABC*
> ABC
> ABC-
> ABC+
> ABC
> QWE~
> ASD+
> ASD#
> KLASDHK-
> KLASDHK+
> KLASDHK
> KLASDHK*
>
>
> what I want to do is 'select distinct(data) [ignoring non alphanumeric
> characters] order by data'
Write a function that strips off the suffixes and do 'select distinct
voodoo(data) ...'.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/