From: phil@Stimpy.netroedge.com
To: Byron Nikolaidis <byron.nikolaidis@home.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: Inverted result set, why?
Date: Thu, 29 Jun 2000 19:35:08 -0700
Message-ID: <20000629193508.I7690@Stimpy.netroedge.com> (raw)
In-Reply-To: <003901bfe238$f2603320$6401a8c0@byron>
References: <200006271130.GAA01884@eperke.themail.com>
<003901bfe238$f2603320$6401a8c0@byron>
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@netroedge.com -- http://www.netroedge.com/~phil
PGP F16: 01 D2 FD 01 B5 46 F4 F0 3A 8B 9D 7E 14 7F FB 7A
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: phil@Stimpy.netroedge.com, byron.nikolaidis@home.com
Subject: Re: Inverted result set, why?
In-Reply-To: <20000629193508.I7690@Stimpy.netroedge.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox