| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Mount | 2000-06-30 07:55:13 | RE: JDBC Driver support for SQLException.getSQLState () |
| Previous Message | Byron Nikolaidis | 2000-06-30 02:14:39 | Re: Inverted result set, why? |