From: Oscar Serrano <oserra@fondos.net>
To: pgsql-interfaces@postgreSQL.org
Subject: RE: [INTERFACES] last record selection
Date: Tue, 30 Nov 1999 10:06:07 +0100
Message-ID: <004301bf3b12$29807dc0$2e0aebc3@pep> (raw)
References: <4.1.19991130022532.00a01390@athena.ualr.edu>
----- 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
>
> ************
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: oserra@fondos.net
Subject: RE: [INTERFACES] last record selection
In-Reply-To: <004301bf3b12$29807dc0$2e0aebc3@pep>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox