Re: [GENERAL] Is there a better way to do this?

[Osvaldo Rosario Kussama]

Wei Weng escreveu:

Hi all

I want to implement something like the following:

CREATE OR REPLACE FUNCTION AddDays
       (TIMESTAMP WITHOUT TIME ZONE
       , INT)
RETURNS TIMESTAMP WITHOUT TIME ZONE AS '
DECLARE
       time ALIAS FOR $1;
       days ALIAS FOR $2;
BEGIN
       RETURN time+days*24*3600*''1 second''::INTERVAL;
END;
' LANGUAGE 'plpgsql';

Basically the function takes two parameters, and add the second one (as days) onto the first one (as timestamp without timezone) I don't really like this implementation. Is there a more concise way to do this?

CREATE OR REPLACE FUNCTION AddDays
       (time TIMESTAMP WITHOUT TIME ZONE
       , days INT)
RETURNS TIMESTAMP WITHOUT TIME ZONE AS $$
BEGIN
       RETURN time + days*'1 day'::INTERVAL;
END;
$$ LANGUAGE 'plpgsql';


Osvaldo

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend