------=_Part_7980_29135660.1209044090089
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Dear All,
How I can check a substring is a valid number in postgresql ?
example:
I have a query
select max(substring(code,2,length(code))::INT) from emp where
substring(code,0,2) = 'A';
code
========
A0001
A0002
ABC005
S0002
This query fails because of ABC002, how I can avoid this error , if there
is
a any way to check substring(code,1,length(code)) is a number ,then i can
correct the query by put it in where condition.
I want to get the result as 2(ie want to avoid checking ABC005
is there is any built in function to check the substring is a number in
postgresql?
Iam using postgres 8.1.8
pls help me
thanks in advance:
Anoop
------=_Part_7980_29135660.1209044090089
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
<span class="HcCDpe">Dear All,<br>
<br>
How I can check a substring is a valid number in
postgresql ?<br>
<br>
<br>
example:<br>
<br>
I have a query <br>
<br>
select max(substring(code,2,length(code))::INT) from emp where
substring(code,0,2) = 'A'; <br>
<br>
<br>
<br>
code <br>
========<br>
A0001<br>
A0002<br>
ABC005<br>
S0002<br>
<br>
This query fails because of </span><span class="HcCDpe">ABC002, how I can
avoid this error , if there is a any way to check </span><span
class="HcCDpe">substring(code,1,length(code)) is a number ,then i
can correct the query by put it in where condition.<br>
<br>
I want to get the result as 2(ie want to avoid checking ABC005<br>
<br>
is there is any built in function to check the substring is a number in
postgresql?<br>
<br>
Iam using postgres 8.1.8 <br>
<br>
pls help me <br><br>
<br>
thanks in advance:<br>
<br>
Anoop</span>
------=_Part_7980_29135660.1209044090089--
|
