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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Browse pgsql-interfaces by date

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