Re: select substr???

From: "Tim Johnson" <tim(at)celestialdesign(dot)co(dot)uk>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: select substr???
Date: 2001-04-09 17:05:55
Message-ID: NBBBLHOPPPPCHCIABAFGOEDEDKAA.tim@celestialdesign.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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'

is there a way to do that? Changing the data stored in the table is not an
option as the suffixes are needed elsewhere..

Please help !!

Thanks,
Tim.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 2001-04-09 18:38:50 Re: Re: select substr???
Previous Message Ross J. Reedstrom 2001-04-09 17:02:21 Re: Casting numeric to text