Re: Alternative to MS Access Last() function - Mailing list pgsql-novice

From Scott Ford
Subject Re: Alternative to MS Access Last() function
Date
Msg-id CAA10533F41BB7448F7659D4D06719074A00BE@cx41.800onemail.com
Whole thread Raw
In response to Alternative to MS Access Last() function  ("Scott Ford" <Scott.Ford@bullfrogpower.com>)
Responses Re: Alternative to MS Access Last() function
Re: Alternative to MS Access Last() function
List 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@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

pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Alternative to MS Access Last() function
Next
From: " Jaromír Kamler"
Date:
Subject: Re: delay of function