Re: Sorting by numerical order

From: Steve Atkins <steve(at)blighty(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Sorting by numerical order
Date: 2004-03-14 23:09:06
Message-ID: 20040314230906.GA11721@gp.word-to-the-wise.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2004-03-14 23:09:54 Re: Sorting by numerical order
Previous Message Eric B.Ridge 2004-03-14 23:06:38 Re: How reliable are the stats collector stats?