On 4/12/07, Raymond O'Donnell <[EMAIL PROTECTED]> wrote:
On 11/04/2007 21:15, Jon Sime wrote:
>> This is probably a very simple one, but I just can't see the answer and
>> it's driving me nuts. I have a table holding details of academic terms,
Many thanks indeed to all who replied - I particularly like Jeff's
solution, and will use that one.
I think this is by far the cleanest:
select * from term where start_date > (select start_date from term
where name = 'foo') order by start_date limit 1;
merlin
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
