Skip site navigation (1) Skip section navigation (2)

Re: Time problem again?

From: Bjørn T Johansen <btj(at)havleik(dot)no>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Time problem again?
Date: 2003-09-30 08:50:21
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On Tue, 2003-09-30 at 10:42, Richard Huxton wrote:

> So - your rule is something like:
> For some block of times...
>   IF max(my_time) - min(my_time) > 12 hours
>   THEN sort "through midnight"
>   ELSE sort "naturally"
> Which is what Tom said (I was wondering where he got his 12 hours from).
> Have I got that right?

Yes, that sounds about right.. :)
But how do I code this in an Select statement?


In response to


pgsql-general by date

Next:From: Karsten HilbertDate: 2003-09-30 09:13:04
Subject: Re: Time problem again?
Previous:From: Angel TodorovDate: 2003-09-30 08:43:19
Subject: pg_hba.conf

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group