Re: date problem - Mailing list pgsql-general

From tony
Subject Re: date problem
Date
Msg-id 1116233301.8944.1.camel@hush
Whole thread Raw
In response to Re: date problem  (Roman Neuhauser <neuhauser@sigpipe.cz>)
List 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


pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: date problem
Next
From: tony
Date:
Subject: Re: date problem