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
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 |