| From: | "Fernando P(dot) Schapachnik" <fernando(at)schapachnik(dot)com(dot)ar> |
|---|---|
| To: | "Stefan Waidele jun(dot)" <St(dot)Waidele(dot)jun(at)Krone-Neuenburg(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Re: interval question |
| Date: | 2001-03-06 12:28:00 |
| Message-ID: | 200103061228.f26CS1Z00578@funes.schapachnik.com.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
En un mensaje anterior Stefan Waidele jun. escribió:
> At 21:59 05.03.2001 -0300, Fernando P. Schapachnik wrote:
> >[...]
> > 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?
>
> Yes, maybe...
>
> '0:00'+start <= '0:00'+now <= start+duration
When I do:
select * from table where '0:00'::time+'now'<=start+duration
I lost conection to the backend. Why?
Fernando P. Schapachnik
fernando(at)schapachnik(dot)com(dot)ar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paulo Parola | 2001-03-06 13:29:12 | Reliable and up-to-date PostgreSQL virtual hosting suggestions |
| Previous Message | dev | 2001-03-06 12:07:12 | Re: interval question |