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

[SQL] Verifying data type

2004-08-16 Thread Elieser Leão
umbernumber; begin begin select p_valor into v_number from dual; v_resultado := 0; exception when others then v_resultado := 1; end; return v_resultado; end; / show err -- Elieser Leão Sorry for my bad english... ---(end of broa