Skip site navigation (1) Skip section navigation (2)

Re: Getting The Last Entry

From: Thom Brown <thom(at)linux(dot)com>
To: Francisco Leovey <fleovey(at)yahoo(dot)com>
Cc: PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Getting The Last Entry
Date: 2010-09-10 15:33:28
Message-ID: AANLkTinK=n+wKpOA+MXM1=MP71gM8nEWH73Yf8+XuRi+@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
On 10 September 2010 16:31, Francisco Leovey <fleovey(at)yahoo(dot)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

In response to

Responses

pgsql-novice by date

Next:From: Luiz Eduardo Cantanhede NeriDate: 2010-09-10 15:49:17
Subject: Re: Getting The Last Entry
Previous:From: ThangalinDate: 2010-09-10 15:14:20
Subject: Change view with dependencies function: PG 8.3

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group