Re: dynamic interval in plpgsql

Thilo,

> i work on a stored procedure which does some timespecific calculations
> in plpgsql.
> in a loop i want  to increase a timestamp by a changing interval. but i
> found no way to assign a variable to INTERVAL .
> finally i used plpython for the function but i still wonder if it could
> be done with plpgsql?

I'm sure this is possible, but from your description I can't figure out what
you're trying to do.  Please be more explicit.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco