date problem - Mailing list pgsql-general

From tony
Subject date problem
Date
Msg-id 1116229689.10597.39.camel@hush
Whole thread Raw
Responses Re: date problem
Re: date problem
List 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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: function bit(integer)
Next
From: Roman Neuhauser
Date:
Subject: Re: date problem