On Thu, Mar 5, 2009 at 9:48 AM, Nico Grubert <nicogrubert@xxxxxxxxx> 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() ? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
