Damian Georgiou wrote:
Hi All,

I am having an issue with a function where it used to run in a previous installation of postgres under windows. The box has since been
ERROR:  function sp_schedulefromdate("unknown") does not exist
LINE 1: select sp_scheduleFromDate('2008-01-01');
               ^
HINT: No function matches the given name and argument types. You may need to add explicit type casts.


I suppose you need to add an explicit cast, as it says in the error message. This means that instead of sp_scheduleFromDate('2008-01-01'); which is what you got now, you use sp_scheduleFromDate('2008-01-01'::date); which seems to be what the function expects.



--
Tommy Gildseth

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to