Skip site navigation (1)
Skip section navigation (2)
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.
Peripheral Links
Header And Logo
|
Site Navigation
Checking for a number
- From: Warren <warren(at)clarksnutrition(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Checking for a number
- Date: Wed, 27 Jun 2007 10:30:43 -0700
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
- Follow-Ups:
- Re: Checking for a number
- From: Osvaldo Rosario Kussama
- Re: Checking for a number
- Prev by Date: Re: autovacumm not working ?
- Next by Date: Re: Checking for a number
- Previous by thread: How do you handle shared memory corruption issues? (contrib/xml2)
- Next by thread: Re: Checking for a number
- Indexes: