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
=?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 th
Hello guys,
I have a function like this
CREATE OR REPLACE FUNCTION "public"."f_tipo_campo" (varchar) RETURNS
numeric AS
'declare
p_valor ALIAS FOR $1;
v_resultado varchar;
begin
v_resultado := 1;
<> return v_resultado;
<>end;
<><>' LANGUAGE 'plpgsql'
<>
<>
I need to verify if the data in p_
