Hello:
        Maybe somebody on the list can give me a hand with this. I
have:

id serial,
start time,
duration time

        (That is, ids have an start time and a duration).

        I want to know which ids are current, ie, which satisfy
start<=now<=start+duration.

        The problem is that start+duration is an interval, and I
can't find the way to cast now to interval or interval to time or
tinterval in order to make the comparison.

        Any ideas?

        Thanks in advance.

Fernando P. Schapachnik
[EMAIL PROTECTED]

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to