I thought all ambiguous function calls would generate an error:

ERROR:  function g("unknown") is not unique
HINT:  Could not choose a best candidate function. You may need to add 
explicit type casts.

but this doesn't seem to be the case.  The below code creates overloaded 
functions that do not produce this error when called with a NULL argument.

jurka=# CREATE FUNCTION g(int) RETURNS int AS 'SELECT 1;' LANGUAGE sql;
CREATE FUNCTION
jurka=# CREATE FUNCTION g(float) RETURNS int AS 'SELECT 2;' LANGUAGE sql;
CREATE FUNCTION
jurka=# SELECT g(NULL);
 g 
---
 2
(1 row)


Kris Jurka


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to