It works nice!
Manuel Sugawara wrote:
Josué Maldonado <[EMAIL PROTECTED]> writes:
Hello list,
That's my question, I can't figure out a way to know if a given string is digit, soemthing like this:
ISDIGIT("ARWA") = False ISDIGIT("5334") = True
If anyone know a way to get that done, I'll appreciate the help.
create function isdigit(text) returns boolean as ' select $1 ~ ''^(-)?[0-9]+$'' as result ' language sql;
masm=# select isdigit('ARWA');
isdigit
---------
f
(1 row)
masm=# select isdigit('5334');
isdigit
---------
t
(1 row)
Regards,
Manuel.
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
-- Josué Maldonado.
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
