"Costin Manda" <siderite@xxxxxxxxx> writes:
> select setuptime::timestamp from billing; - error (cannot cast type
> character varying to timestamp without timezone!?)
It works for me in 8.0. In some releases you need to cast to text
first, for example in 7.4:
regression=# select '2005-10-10 10:10:10'::varchar::timestamp;
ERROR: cannot cast type character varying to timestamp without time zone
regression=# select '2005-10-10 10:10:10'::varchar::text::timestamp;
timestamp
---------------------
2005-10-10 10:10:10
(1 row)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
