On Jan 12, 2005, at 8:35, Tom Lane wrote:
The recommended locution is
SELECT TIMESTAMP WITH TIME ZONE 'epoch' + <x> * INTERVAL '1 second';
Of course you can wrap this up in a function if you prefer (not sure why
we haven't done so already).
It's in the queue for 8.1.
<http://candle.pha.pa.us/mhonarc/patches2/msg00090.html>
Michael Glaesemann grzm myrealbox com
---------------------------(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
