Fijil Stephen <fijil.step...@mooobleiit.com> writes: > Hi I am created a function > CREATE FUNCTION one(float,float) RETURNS float AS $$ > select $1+$2 AS result; > $$ LANGUAGE SQL; > Its worked
> Then > I droped the function > Drop function one(float,float) > Its also worked > Then I typed > Select one(18.5,12.4) > Ho⦠the result appers as 31.9 I don't see any reason to think this is a bug; it just indicates that you have another function named one() that can accept two numeric parameters. Perhaps it is declared differently than (float, float), or perhaps it's in a different schema in your search path. It might help to do "\df one" in psql to see what you've got. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs