Thread: i cannot able to delete the sql function permenently

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=E2=80=A6 the result  appers as 31.9

How is it
???
Pls replay

Fijil Stephen <fijil.stephen@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