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

Re: Inverted result set, why?

From: phil(at)Stimpy(dot)netroedge(dot)com
To: Byron Nikolaidis <byron(dot)nikolaidis(at)home(dot)com>, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Inverted result set, why?
Date: 2000-06-30 02:35:08
Message-ID: 20000629193508.I7690@Stimpy.netroedge.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
On Thu, Jun 29, 2000 at 10:14:39PM -0400, Byron Nikolaidis wrote:
> If you want a specific order based on the time, you could add a timestamp
> field to the table that would default to the current time when the record
> was inserted (see create table...default...) .  Then you can "order by" on
> the timestamp, either ascending or descending if desired.

That's exactly right.  Most tables I deal with contain at least a
timestamp field and a creator field (aka the source of the data).  In
general, if you think you'll need it, then you should store it. 
Storage space is realitively cheap. 

Good luck!


Phil

-- 
Philip Edelbrock -- IS Manager -- Edge Design, Corvallis, OR
   phil(at)netroedge(dot)com -- http://www.netroedge.com/~phil
 PGP F16: 01 D2 FD 01 B5 46 F4 F0  3A 8B 9D 7E 14 7F FB 7A

In response to

pgsql-interfaces by date

Next:From: Peter MountDate: 2000-06-30 07:55:13
Subject: RE: JDBC Driver support for SQLException.getSQLState ()
Previous:From: Byron NikolaidisDate: 2000-06-30 02:14:39
Subject: Re: Inverted result set, why?

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