Re: [SQL] finding the most recent records

From: Mark Jewiss <mark(at)office(dot)knowledge(dot)com>
To: JT Kirkpatrick <jt-kirkpatrick(at)mpsllc(dot)com>
Cc: "'pgsql-sql(at)hub(dot)org'" <pgsql-sql(at)hub(dot)org>
Subject: Re: [SQL] finding the most recent records
Date: 1999-04-30 14:55:45
Message-ID: Pine.BSF.4.05.9904301554190.20696-100000@office.knowledge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, 30 Apr 1999, JT Kirkpatrick wrote:

> I didn't find who originally asked how to do this, but it IS possible to
> identify the most recent if you have a field in the table defined as

This will work, but Postgresql contains a specific datatype that you can
have as a unique identifier. Every time a row is inserted it will take the
number and increase by one. Uses an integer to do this.

Cheers,

Mark.
--
Mark Jewiss
Knowledge Matters Limited

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jackson, DeJuan 1999-04-30 15:39:27 RE: [SQL] Limit Questions 2
Previous Message JT Kirkpatrick 1999-04-30 14:31:06 finding the most recent records