From: | "Scott Ford" <Scott(dot)Ford(at)bullfrogpower(dot)com> |
---|---|
To: | "Michael Fuhr" <mike(at)fuhr(dot)org> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Alternative to MS Access Last() function |
Date: | 2006-03-01 18:31:28 |
Message-ID: | CAA10533F41BB7448F7659D4D06719074A00BE@cx41.800onemail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)fuhr(dot)org]
Sent: March 1, 2006 1:21 PM
To: Scott Ford
Cc: pgsql-novice(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Jaromír Kamler | 2006-03-01 18:33:54 | Re: delay of function |
Previous Message | Michael Fuhr | 2006-03-01 18:21:02 | Re: Alternative to MS Access Last() function |