Postgres Pro
Downloads
Home   >   mailing lists

Checking for a number - Mailing list pgsql-general

From Warren
Subject Checking for a number
Date
Msg-id 46829EC3.6090703@clarksnutrition.com
Whole thread Raw
Responses Re: Checking for a number  (Osvaldo Rosario Kussama <osvaldo_kussama@yahoo.com.br>)
List pgsql-general
Tree view 
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 by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: autovacumm not working ?
Next
From: Lee Keel
Date:
Subject: Re: Checking for a number