Re: Getting The Last Entry - Mailing list pgsql-novice

From Luiz Eduardo Cantanhede Neri
Subject Re: Getting The Last Entry
Date
Msg-id AANLkTim=CsCmhcFrGQJyoQ-+zk2vfi8cfLGuaJ0f59Fb@mail.gmail.com
Whole thread Raw
In response to Re: Getting The Last Entry  (Thom Brown <thom@linux.com>)
Responses Re: Getting The Last Entry  (Francisco Leovey <fleovey@yahoo.com>)
Re: Getting The Last Entry  (Lew <noone@lewscanon.com>)
List pgsql-novice
Once I suggested to use oid, but some guys here said was a poor design.

On Fri, Sep 10, 2010 at 12:33 PM, Thom Brown <thom@linux.com> wrote:
On 10 September 2010 16:31, Francisco Leovey <fleovey@yahoo.com> wrote:
>
> if by "last" you mean the last row inserted, use
>
> select *,oid from table order by oid DESC limit 1
>
> (asuming you use OID's)

(copying in list with your response)

--
Thom Brown
Twitter: @darkixion
IRC (freenode): dark_ixion
Registered Linux user: #516935

--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

pgsql-novice by date:

Previous
From: Thom Brown
Date:
Subject: Re: Getting The Last Entry
Next
From: Francisco Leovey
Date:
Subject: Re: Getting The Last Entry