Re: Non-aggregate values attached to aggregates? - Mailing list pgsql-general

On Thu, Dec 16, 2004 at 01:38:19PM -0800, Benjamin Smith wrote:

> I have a list of students, and a list of enrollment records, and I'm trying to
> get a list of students and their most recent enrollment/disenrollment dates.

If you don't mind using a non-standard construct, see the documentation
for SELECT DISTINCT ON.

http://www.postgresql.org/docs/7.4/static/queries-select-lists.html#QUERIES-DISTINCT
http://www.postgresql.org/docs/7.4/static/sql-select.html#SQL-DISTINCT

> Dates are kept as ]YYYYMMDD', eg 2004114 for Nov 14, 2004.

Why not use a DATE type?  You can reformat it with to_char() if
need be.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/