Re: [BUGS] Unexpected behaviour of numeric datatype when mixed with,float4, domains and plpgsql variables

#1

Ezequiel Tolnay <mail (AT) etolnay (DOT) com.ar> writes:

Quote:

CREATE DOMAIN currency AS numeric(15,4);
CREATE TABLE test (id serial, amt currency);
CREATE FUNCTION f_test(currency) RETURNS currency AS $$
DECLARE n currency;
BEGIN n := $1 * 0.2::float4;
INSERT INTO test (amt) VALUES (n); RETURN n;
END $$ LANGUAGE PLPGSQL;

plpgsql doesn't currently enforce domain constraints, so the assignment
to n isn't doing the rounding that you expect. Until someone gets
around to fixing that, an explicit coercion is probably what you need:

n := cast($1 * 0.2::float4 AS currency);

Keep in mind also that declaring a function result value as a domain
is pretty dangerous, because none of the PLs enforce domain constraints
on their results.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: [BUGS] Unexpected behaviour of numeric datatype when mixed with,float4, domains and plpgsql variables

mailing.database.pgsql-bugs mailing.database.pgsql-bugs

Re: [BUGS] Unexpected behaviour of numeric datatype when mixed with,float4, domains and plpgsql variables - 04-10-2005 , 04:21 PM