Re: [GENERAL] Stored procs / functions - execution failure

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