Re: [GENERAL] Debugging pgsql function date error

2009-05-28 Thread Adrian Klaver
On Thursday 28 May 2009 5:36:10 pm Rory Campbell-Lange wrote: > I have a long plpgsql function which takes a date as one of its > arguments but I am receiving an error for another date! I'm using 8.3 on > Debian. > > CREATE OR REPLACE FUNCTION > fn_alert01_maker(integer, integer, integer, integ

[GENERAL] Debugging pgsql function date error

2009-05-28 Thread Rory Campbell-Lange
I have a long plpgsql function which takes a date as one of its arguments but I am receiving an error for another date! I'm using 8.3 on Debian. CREATE OR REPLACE FUNCTION fn_alert01_maker(integer, integer, integer, integer, date, integer) RETURNS SETOF alert_info AS $$ DECLARE userid