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  (Francisco Leovey <fleovey@yahoo.com>)
Re: Getting The Last Entry  (Lew <noone@lewscanon.com>)
Список 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 по дате отправления:

Предыдущее
От: Thom Brown
Дата:
Сообщение: Re: Getting The Last Entry
Следующее
От: Francisco Leovey
Дата:
Сообщение: Re: Getting The Last Entry