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