Checking for a number

Поиск
Список
Период
Сортировка
От Warren
Тема Checking for a number
Дата
Msg-id 46829EC3.6090703@clarksnutrition.com
обсуждение исходный текст
Ответы Re: Checking for a number
Список pgsql-general
I need to check if the last two characters of a field are a number. I am
trying something like this but it does not want to work.

substring(TRIM(field8) from '..$') SIMILAR TO '\d\d'

How should I do this?

--
Thanks,

Warren Bell

В списке pgsql-general по дате отправления: