Actually, I think I just figured it out. I'm not sure that I totally
understand it - I've been passed the problem of converting it from
someone else. But according to the documentation:
-------------
The LAST function returns the value of the last record in the specified
field.
Syntax:
SELECT LAST(column) AS [expression]
FROM table
Example:
SELECT LAST(Age) AS highest_age
FROM Persons
ORDER BY Age
--------------
So I think that I should just be able to use MAX(). Right?
-----Original Message-----
From: Michael Fuhr [mailto:mike@fuhr.org]
Sent: March 1, 2006 1:21 PM
To: Scott Ford
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Alternative to MS Access Last() function
On Wed, Mar 01, 2006 at 01:11:56PM -0500, Scott Ford wrote:
> Does anyone know of a good alternative in postgres to the MS access
last
> function?
What does it do? People who don't use Access might be able to
answer if they knew what functionality you're after.
--
Michael Fuhr