RE: [INTERFACES] last record selection

Поиск
Список
Период
Сортировка
От Oscar Serrano
Тема RE: [INTERFACES] last record selection
Дата
Msg-id 004301bf3b12$29807dc0$2e0aebc3@pep
обсуждение исходный текст
Ответ на last record selection  ("Stanislav A. Filippov" <safilippov@ualr.edu>)
Список 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 по дате отправления:

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: [INTERFACES] Asynchronous connection functions - patch submitted
Следующее
От: "Stanislav A. Filippov"
Дата:
Сообщение: [INTERFACES] last record selection