9.2 timestamp function syntax error - Mailing list pgsql-general

From Guy Rouillier
Subject 9.2 timestamp function syntax error
Date
Msg-id 513573D9.3050605@gmail.com
Whole thread Raw
Responses Re: 9.2 timestamp function syntax error
List pgsql-general
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?

Thanks.

--
Guy Rouillier


pgsql-general by date:

Previous
From: Daniel Farina
Date:
Subject: Re: [HACKERS] Floating point error
Next
From: Stefan Keller
Date:
Subject: Database (Schema) Objects?