Search Postgresql Archives

Re: Stored procs / functions - execution failure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux