Re: [SQL] Mail about typecast - Mailing list pgsql-sql

Herouth Maoz <herouth@oumail.openu.ac.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