Louis-David Mitterrand <[EMAIL PROTECTED]> writes: > On Wed, Nov 07, 2007 at 10:35:08AM -0500, Tom Lane wrote: >> SELECT EXTRACT(EPOCH FROM MAX(mydate)) FROM myTable
> Is using casts for the same purpose deprecated?
> SELECT current_date::timestamp::abstime::int4;
Well, type abstime is deprecated --- it's got a Y2038 problem.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
