Re: Sorting by numerical order - Mailing list pgsql-general

From Mike Nolan
Subject Re: Sorting by numerical order
Date
Msg-id 200403150158.i2F1wte2009824@gw.tssi.com
Whole thread Raw
In response to Re: Sorting by numerical order  (Martijn van Oosterhout <kleptog@svana.org>)
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgeSQL problem (server crashed?)
Next
From: Karel Zak
Date:
Subject: Re: Sorting by numerical order