RE: [INTERFACES] last record selection - Mailing list pgsql-interfaces

From Oscar Serrano
Subject RE: [INTERFACES] last record selection
Date
Msg-id 004301bf3b12$29807dc0$2e0aebc3@pep
Whole thread Raw
In response to last record selection  ("Stanislav A. Filippov" <safilippov@ualr.edu>)
List pgsql-interfaces
----- Original Message ----- 
From: Stanislav A. Filippov <safilippov@ualr.edu>
To: <pgsql-interfaces@postgreSQL.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
> 
> ************
> 


************




pgsql-interfaces by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: [INTERFACES] Asynchronous connection functions - patch submitted
Next
From: "Stanislav A. Filippov"
Date:
Subject: [INTERFACES] last record selection