date problem

From: tony <tony(at)tgds(dot)net>
To: postgres list <pgsql-general(at)postgresql(dot)org>
Subject: date problem
Date: 2005-05-16 07:48:08
Message-ID: 1116229689.10597.39.camel@hush
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I thought this would be a classic sort of query but google did no give
me the answer.

I am attempting to select records where one of the dates is the latest
date before today

select max(date) from expo where date < now()

works for one record but other fields I need must be in aggregate or
grouped. Is there a simple SQL request to get the most recent records
from a set of joined tables?

TIA

Tony

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Roman Neuhauser 2005-05-16 08:30:55 Re: date problem
Previous Message Tom Lane 2005-05-15 21:33:49 Re: function bit(integer)