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

From: Nico Grubert <nicogrubert(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: After Upgrade from 8.2.6 to 8.3.6: function to_timestamp does not exist
Date: 2009-03-05 16:48:27
Message-ID: 49B0025B.2030007@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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:
------------------------------------------------------------------------
ERROR: function to_timestamp(timestamp without time zone, unknown) does
not exist
LINE 3: WHERE to_timestamp(a.from_datetime,'YYYY/MM/DD') >= to_tim...
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
------------------------------------------------------------------------

Is the "to_timestamp" function not supported anymore in 8.3.6? I could
not read anything about it in the 8.3 documentation.

Regards
Nico

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hiroshi Saito 2009-03-05 17:17:17 Re: encoding of PostgreSQL messages
Previous Message Stuart Luppescu 2009-03-05 16:39:11 Postgres with phpScheduleIt