Search Postgresql Archives
Checking for a number
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
:
pgsql-general@xxxxxxxxxxxxxx
Subject
: Checking for a number
From
: Warren <
warren@xxxxxxxxxxxxxxxxxxx
>
Date
: Wed, 27 Jun 2007 10:30:43 -0700
User-agent
: Thunderbird 1.5.0.12 (Windows/20070509)
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
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: Checking for a number
From:
Osvaldo Rosario Kussama
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
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
