Re: Sorting by numerical order

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: kleptog(at)svana(dot)org
Cc: peter_e(at)gmx(dot)net (Peter Eisentraut), cool_screen_name90001(at)yahoo(dot)com (CSN), pgsql-general(at)postgresql(dot)org
Subject: Re: Sorting by numerical order
Date: 2004-03-15 01:58:55
Message-ID: 200403150158.i2F1wte2009824@gw.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Regular expressions? Something like:
>
> column ~ '^[-+]?[0-9]+(\.[0-9]+)?$'

Oh, that's too easy. Duh! (Coming from years in an Oracle 7 environment,
I sometimes forget regex are there, I guess.)
--
Mike Nolan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karel Zak 2004-03-15 07:04:06 Re: Sorting by numerical order
Previous Message Tom Lane 2004-03-15 01:56:07 Re: PostgeSQL problem (server crashed?)