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

Re: Time problem again?

From: "Daniel Schuchardt" <daniel_schuchardt(at)web(dot)de>
To: "'Postgres General'" <pgsql-general(at)postgresql(dot)org>
Cc: 'Bjørn T Johansen' <btj(at)havleik(dot)no>
Subject: Re: Time problem again?
Date: 2003-09-29 11:44:48
Message-ID: 000001c3867f$1cbd9160$ed00a8c0@DSVAIO (view raw, whole thread or download thread mbox)
Lists: pgsql-general
No, not really
perhaps you can do a ORDER BY (oid || yourtimefield). So you have the
RecordOrder in the way the records where inserted.

I need to sort some data based on a Time field and the times can cross
both midnight and noon. As far as I can tell, there is no way to solve
this without also supplying a date or am I missing something?



In response to


pgsql-general by date

Next:From: Nigel J. AndrewsDate: 2003-09-29 11:47:11
Subject: Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)
Previous:From: Richard HuxtonDate: 2003-09-29 11:40:25
Subject: Re: Time problem again?

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