Re: [PATCHES] to_timestamp overloaded to convert from Unix epoch

2005-06-09 Thread Bruce Momjian
Updated patch attached with both documentation portions --- applied. --- Michael Glaesemann wrote: Please find attached a patch (diff -c against cvs HEAD) to add a function that accepts a double precision argument

Re: [PATCHES] to_timestamp overloaded to convert from Unix epoch

2004-08-17 Thread Bruce Momjian
This has been saved for the 8.1 release: http:/momjian.postgresql.org/cgi-bin/pgpatches2 --- Michael Glaesemann wrote: Please find attached a patch (diff -c against cvs HEAD) to add a function that accepts a

Re: [PATCHES] to_timestamp overloaded to convert from Unix epoch

2004-08-14 Thread Michael Glaesemann
On Aug 15, 2004, at 1:19 AM, Tom Lane wrote: There was however another patch submitted recently that seemed to duplicate yours functionally but used a different syntax --- I think the guy had started by looking at extract(epoch from timestamp) rather than to_timestamp. Other than Chris'

Re: [PATCHES] to_timestamp overloaded to convert from Unix epoch

2004-08-14 Thread Tom Lane
Michael Glaesemann [EMAIL PROTECTED] writes: On Aug 15, 2004, at 1:19 AM, Tom Lane wrote: There was however another patch submitted recently that seemed to duplicate yours functionally but used a different syntax --- I think Other than Chris' suggestion of extract(timestamp from epoch)? [

Re: [PATCHES] to_timestamp overloaded to convert from Unix epoch

2004-08-14 Thread Bruce Momjian
TODO here? --- Tom Lane wrote: Michael Glaesemann [EMAIL PROTECTED] writes: On Aug 15, 2004, at 1:19 AM, Tom Lane wrote: There was however another patch submitted recently that seemed to duplicate yours functionally

Re: [PATCHES] to_timestamp overloaded to convert from Unix epoch

2004-08-14 Thread Bruce Momjian
Sorry, I now see I should add the patch to the 8.1 queue. --- Bruce Momjian wrote: TODO here? --- Tom Lane wrote: Michael Glaesemann [EMAIL

[PATCHES] to_timestamp overloaded to convert from Unix epoch

2004-08-11 Thread Michael Glaesemann
Please find attached a patch (diff -c against cvs HEAD) to add a function that accepts a double precision argument assumed to be a Unix epoch timestamp and returns timestamp with time zone, and accompanying documentation. Usage: test=# select to_timestamp(200120400); to_timestamp