Re: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist

On Thu, Mar 5, 2009 at 9:48 AM, Nico Grubert <nicogrubert@gmail.com> wrote:
> Dear list members
>
> I have upgraded my PostgreSQL 8.2.6 to 8.3.6 and I am having trouble with
> calling "to_timestamp" function.
>
> Here is the query I use:
>
>  SELECT a.*
>  FROM tblevent a
>  WHERE to_timestamp(a.from_datetime,'YYYY/MM/DD') >= to_timestamp(
> NOW(),'YYYY/MM/DD' )
>  ORDER BY a.from_datetime
>
> In PostgreSQL 8.2.6 everything works fine.
> In PostgreSQL 8.3.6 I get the following error:

OK, so you want to see if a timestamp is greater than now()?  Why not
just compare them?

where a.from_datetime >= now()

?