that would behave in a more expected manner, or at
> least document precisely the current behaviour in the documentation.
>
> Best regards,
> Laurent
>
>
> ---(end of broadcast)---
> TIP 1: if posting/reading through Usenet, please send an a
mber($1,$2);
END;
$$ LANGUAGE PLPGSQL IMMUTABLE;
Tests...
=# select my_to_number('123.0','99');
ERRO: TEXT 123.0 is not a valid NUMBER
=# select my_to_number('1230','99');
my_to_number
------
1230
(1 registro)
Tempo: 0,734 ms
--
William Leite Araújo
DBA - QualiConsult
2007/8/3, William Leite Araújo <[EMAIL PROTECTED]>:
>
> CREATE OR REPLACE my_to_number(text,text) RETURNS number AS
OOOps... CREATE OR REPLACE FUNCTION ...
$$
> BEGIN
> IF NOT textregexeq($1,'[0-9]{'||length($2)||'}') THEN
> RAISE EXCEPTION &#x
d 1 =
> any (objects.field3)", not return the register.
>
> all these commands when i execute in "execute query" of pgadminIII not
> have
> problem.
>
> -----------(end of broadcast)---
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>choose an index scan if your joining column's datatypes do not
>match
>
--
William Leite Araújo
Estudante de paternidade - 17a semana
s automatically, and works fine...
-- William Leite Araújo
s
for users to view).Thanks,Stephen-BEGIN PGP SIGNATURE-Version: GnuPG v1.4.2 (GNU/Linux)iD8DBQFEMZPKrzgMPqB3kigRAkjsAJwJjASObN0lMkuO8w5qbolAxOImlACfTjJ4
HNN2dVp6S6ng5Fc9yIsxGSE==akx8-END PGP SIGNATURE--- William Leite Araújo
The following bug has been logged online:
Bug reference: 2372
Logged by: William Leite Araújo
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.7
Operating system: i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5
(Debian 1:3.3.5-13)
Description:dblink_exec d
