Re: Sorting by numerical order

Поиск
Список
Период
Сортировка
От Steve Atkins
Тема Re: Sorting by numerical order
Дата
Msg-id 20040314230906.GA11721@gp.word-to-the-wise.com
обсуждение исходный текст
Ответ на Re: Sorting by numerical order  (Mike Nolan <nolan@gw.tssi.com>)
Список 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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Sorting by numerical order
Следующее
От: Edwin Pauli
Дата:
Сообщение: Re: PostgeSQL problem (server crashed?)