Kind people,
I hope this one actually does what Tom said. It appears to work :)
Cheers,
D
--
David Fetter [EMAIL PROTECTED] http://fetter.org/
phone: +1 510 893 6100 cell: +1 415 235 3778
Index: func.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/func.sgml,v
retrieving revision 1.180
diff -2 -c -r1.180 func.sgml
*** func.sgml 29 Nov 2003 19:51:37 -0000 1.180
--- func.sgml 4 Dec 2003 22:16:52 -0000
***************
*** 4997,5001 ****
number of seconds since 1970-01-01 00:00:00-00 (can be negative);
for <type>interval</type> values, the total number
! of seconds in the interval
</para>
--- 4997,5002 ----
number of seconds since 1970-01-01 00:00:00-00 (can be negative);
for <type>interval</type> values, the total number
! of seconds in the interval. The third example shows how to
! convert number of seconds since EPOCH into a timestamp.
</para>
***************
*** 5006,5009 ****
--- 5007,5013 ----
SELECT EXTRACT(EPOCH FROM INTERVAL '5 days 3 hours');
<lineannotation>Result: </lineannotation><computeroutput>442800</computeroutput>
+
+ SELECT 'epoch'::timestamptz + 1070430858 * '1 second'::interval;
+ <lineannotation>Result: </lineannotation><computeroutput>2003-12-02
21:54:18-08</computeroutput>
</screen>
</listitem>
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
