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

RE: [INTERFACES] last record selection

From: "Oscar Serrano" <oserra(at)fondos(dot)net>
To: <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: RE: [INTERFACES] last record selection
Date: 1999-11-30 09:06:07
Message-ID: 004301bf3b12$29807dc0$2e0aebc3@pep (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
----- Original Message ----- 
From: Stanislav A. Filippov <safilippov(at)ualr(dot)edu>
To: <pgsql-interfaces(at)postgreSQL(dot)org>
Sent: Tuesday, November 30, 1999 9:27 AM
Subject: [INTERFACES] last record selection

> Can anyone tell me if there is a direct way to SELECT the last record in
> the table,
> without selecting the whole table and retrieving all rows.

I don't know if this can be useful for you:

SELECT * FROM yourtable ORDER BY whatever LIMIT 1

> thanx
> ************

In response to

pgsql-interfaces by date

Next:From: Michael MeskesDate: 1999-11-30 10:27:14
Subject: Re: [INTERFACES] Spanish format on date and numbers
Previous:From: Tatsuo IshiiDate: 1999-11-30 09:00:48
Subject: Re: [INTERFACES] Asynchronous connection functions - patch submitted

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