Re: [SQL] finding the most recent records - Mailing list pgsql-sql

From Mark Jewiss
Subject Re: [SQL] finding the most recent records
Date
Msg-id Pine.BSF.4.05.9904301554190.20696-100000@office.knowledge.com
Whole thread Raw
In response to finding the most recent records  (JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>)
List 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



pgsql-sql by date:

Previous
From: JT Kirkpatrick
Date:
Subject: finding the most recent records
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [SQL] Limit Questions 2