Re: date problem

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

Le lundi 16 mai 2005 à 10:30 +0200, Roman Neuhauser a écrit :

> select *
> from expo
> where date = (select max(date)
> from expo
> where date < now()) as x;

Thanks!

I keep forgetting this for some strange reason... I was putting it in
the "from" instead of the "where"

Tony

In response to

Browse pgsql-general by date

  From Date Subject
Next Message tony 2005-05-16 08:51:37 Re: date problem
Previous Message Richard Huxton 2005-05-16 08:44:22 Re: date problem