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

From Steve Atkins
Subject Re: Sorting by numerical order
Date
Msg-id 20040314230906.GA11721@gp.word-to-the-wise.com
Whole thread Raw
In response to Re: Sorting by numerical order  (Mike Nolan <nolan@gw.tssi.com>)
List pgsql-general
On Sun, Mar 14, 2004 at 04:59:45PM -0600, Mike Nolan wrote:

> An 'isnumeric(column)' boolean function in a case statment would be
> very helpful so that I can program around the bad data.
>
> I'll probably write it in perl, but would making it part of the source
> code provide significantly faster execution?

Couldn't you just use a regex match? foo ~ '-?[0-9]+(\.[0-9]+)?' or
somesuch.

Cheers,
  Steve

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Sorting by numerical order
Next
From: Edwin Pauli
Date:
Subject: Re: PostgeSQL problem (server crashed?)