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, integer, date, integer) > RETURNS SETOF alert_info > AS $$ > DECLARE > userid ALIAS for $1; > alert ALIAS for $2; > since ALIAS for $3; > wait ALIAS for $4; > date_from ALIAS for $5; > days_until ALIAS for $6; > resulter alert_info%rowtype; > since_int INTERVAL; > wait_int INTERVAL; > days_int INTERVAL; > > BEGIN > > days_int := days_until || ' days'; > since_int := since || ' seconds'; > wait_int := wait || ' seconds'; > ... > > and has that argument as one of its WHERE conditions: > ... > WHERE > rs.dt_modified > ((now() - wait_int) - since_int) > AND > rs.d_date >= date_from > AND > rs.d_date <= date_from + days_int > ... > > Wierdly, if I call it like this, it is fine: > SELECT * FROM fn_alert01_maker(0, 1, 845, 5, '2009-05-31', 5); > > But like this it throws an error: > > test=> SELECT * FROM fn_alert01_maker(0, 1, 8450, 5, '2009-05-31', 5); > ERROR: invalid input syntax for integer: "2009-06-01" > CONTEXT: PL/pgSQL function "fn_alert01_maker" line 30 at FOR over > SELECT rows > > > Any ideas? > > Rory What is the code at line 30 ? -- Adrian Klaver aklaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
