Received: from fondos.net (fondos.net [208.234.1.135])
	by hub.org (8.9.3/8.9.3) with ESMTP id EAA21122
	for <pgsql-interfaces@postgreSQL.org>;
	Tue, 30 Nov 1999 04:06:15 -0500 (EST)
	(envelope-from oserra@fondos.net)
Received: from pep (rad010046.radius.teleline.es [195.235.10.46])
	by fondos.net (8.8.8/8.8.5) with SMTP id EAA20449
	for <pgsql-interfaces@postgreSQL.org>; Tue, 30 Nov 1999 04:06:43 -0500
Message-ID: <004301bf3b12$29807dc0$2e0aebc3@pep>
From: "Oscar Serrano" <oserra@fondos.net>
To: <pgsql-interfaces@postgreSQL.org>
References: <4.1.19991130022532.00a01390@athena.ualr.edu>
Subject: RE: [INTERFACES] last record selection
Date: Tue, 30 Nov 1999 10:06:07 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211


----- 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
> 
> ************
>