Received: from smtp012.mail.yahoo.com (smtp012.mail.yahoo.com
 [216.136.173.32])
	by postgresql.org (Postfix) with SMTP id 1C67F475BA9
	for <pgsql-sql@postgresql.org>; Wed, 24 Jul 2002 13:42:21 -0400 (EDT)
Received: from psc.progress.com (HELO Yahoo.com) (janwieck@192.233.92.200 with
	plain)
	by smtp.mail.vip.sc5.yahoo.com with SMTP; 24 Jul 2002 17:42:20 -0000
Message-ID: <3D3EE6F8.C9563D16@Yahoo.com>
Date: Wed, 24 Jul 2002 13:42:16 -0400
From: Jan Wieck <JanWieck@Yahoo.com>
X-Mailer: Mozilla 4.79 [en] (X11; U; Linux 2.2.14-6.1.1smp i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Leao Torre do Vale <elefante400@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Last record
References: <OE70wdVVxUC4pAn8hEA000123f0@hotmail.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200207/387
X-Sequence-Number: 8765

Leao Torre do Vale wrote:

> How can select one field of last
> record of table?

There is no such thing as the "last record of a table" in SQL. Somehow
you must be able to describe what you mean with "last record" and how to
identify that. This would then be translated into a qualification (WHERE
clause) and is the answer to your question.


Jan

-- 

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #