Received: from office.knowledge.com (IDENT:exim@office.knowledge.com [195.40.167.196]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA49137 for ; Fri, 30 Apr 1999 10:55:46 -0400 (EDT) (envelope-from mark@knowledge.com) Received: from mark (helo=localhost) by office.knowledge.com with local-esmtp (Exim 2.10 #1) id 10dEhd-0003GG-00; Fri, 30 Apr 1999 15:55:45 +0100 Date: Fri, 30 Apr 1999 15:55:45 +0100 (BST) From: Mark Jewiss To: JT Kirkpatrick cc: "'pgsql-sql@hub.org'" Subject: Re: [SQL] finding the most recent records In-Reply-To: <01BE92F4.8E44C660.jt-kirkpatrick@mpsllc.com> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: Mark Jewiss 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