Re: [SQL] Verifying data type

2004-08-17 Thread Elieser Leão
Thanks, but the number may be a float, like '1.23,00', '12.323,00', '12,34' :( The regex works fine if it just an integer... Have some regex to "compare"? Tom Lane wrote: =?ISO-8859-1?Q?Elieser_Le=E3o?= [EMAIL PROTECTED] writes: I need to verify if the data in p_valor is

Re: [SQL] Verifying data type

2004-08-16 Thread Tom Lane
=?ISO-8859-1?Q?Elieser_Le=E3o?= [EMAIL PROTECTED] writes: I need to verify if the data in p_valor is just number or it is a string. What is the best way to do this? In PG 8.0 you can just do it exactly the way your Oracle original does, viz try to cram it into a numeric variable and catch the