On 03/05/2013 12:30 AM, Albe Laurenz wrote:
Guy Rouillier wrote:
I don't understand the error resulting from the following progression on
9.2 (specifically "EnterpriseDB 9.2.1.3 on x86_64-unknown-linux-gnu,
compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 64-bit"):
select sysdate => timestamp without time zone
select timestamptz(sysdate) => timestamp with time zone
select timestamp(timestamptz(sysdate)) => ERROR: syntax error at or
near "timestamptz"
OR
select timestamp(sysdate::timestamptz)) => ERROR: syntax error at or
near "sysdate"
I see a function in pg_catalog with signature timestamp(timestamp with
time zone). Why isn't it being applied?
That must be EnterpriseDB's proprietary Postgres Plus, since
regular PostgreSQL doesn't have "sysdate".
Actually that is not the issue.
test=> select version();
version
----------------------
PostgreSQL 9.2.3
This does not work:
test=> select timestamp(now()::timestampz);
ERROR: syntax error at or near "now"
LINE 1: select timestamp(now()::timestampz);
test=> select timestamp(now());
ERROR: syntax error at or near "now"
LINE 1: select timestamp(now());
This does:
test=> select (now()::timestamptz)::timestamp;
now
----------------------------
2013-03-05 06:23:05.169524
(1 row)
test=> select now()::timestamp;
now
---------------------------
2013-03-05 06:24:43.50932
(1 row)
Try to ask EnterpriseDB, they are more likely to be able to help.
Yours,
Laurenz Albe
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
