Re: Getting The Last Entry
| От | Luiz Eduardo Cantanhede Neri |
|---|---|
| Тема | Re: Getting The Last Entry |
| Дата | |
| Msg-id | AANLkTim=CsCmhcFrGQJyoQ-+zk2vfi8cfLGuaJ0f59Fb@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Getting The Last Entry (Thom Brown <thom@linux.com>) |
| Ответы |
Re: Getting The Last Entry
Re: Getting The Last Entry |
| Список | 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 по дате отправления: