Postgres Pro
Downloads
Home   >   mailing lists

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

From Thom Brown
Subject Re: Getting The Last Entry
Date
Msg-id AANLkTinK=n+wKpOA+MXM1=MP71gM8nEWH73Yf8+XuRi+@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  (Luiz Eduardo Cantanhede Neri <lecneri@gmail.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Thangalin
Date:
Subject: Change view with dependencies function: PG 8.3
Next
From: Luiz Eduardo Cantanhede Neri
Date:
Subject: Re: Getting The Last Entry