Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> writes:
> At 16:39 +0300 on 15/06/1999, Tom Lane wrote:
>> select date_part('epoch','12 hours'::timespan) AS float4;
> Probably missing a CAST keyword here, isn't it?
My mistake, this should have been
select CAST (date_part('epoch','12 hours'::timespan) AS float4);
(the parens are required too). The first way just relabels the
output column, it doesn't actually change the datatype :-(
regards, tom lane