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
