Hi Tom, Yes I managed to figured that out, but when was this changed?
It was working in 8.4 but not 9.0 and I could not find anything about this in the release notes. On Jun 29, 2010, at 17:32 , Tom Lane wrote: > Marcel Asio <marcel.a...@redbet.com> writes: >> I've started testing our applications against PostgreSQL 9.0 beta2 and found >> that this function now does not work anymore(rewritten to be as small and >> anonymous as possible) >> CREATE TYPE test_type AS( >> product text, >> amount numeric(30,4) >> ); >> CREATE FUNCTION test_func() RETURNS SETOF test_type AS $$ >> BEGIN >> RETURN QUERY SELECT 'test'::text, 30.2::numeric; >> END; >> $$ LANGUAGE plpgsql STABLE; > > You need to actually coerce the 30.2 to numeric(30,4), not just numeric. > The former behavior wasn't self-consistent. > > regards, tom lane Regards Marcel Asio Network & System Administrator Redbet Technology Mobile: +46 (0)709 13 04 01 Work: +46 (0)8 12 09 99 41 marcel.a...@redbet.com This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden.