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 assum

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 do

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

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 fun

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 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' suggestion

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

2004-08-14 Thread Tom Lane
Michael Glaesemann <[EMAIL PROTECTED]> writes: > On Aug 14, 2004, at 6:50 PM, Christopher Kings-Lynne wrote: >> Maybe you don't need to override to_timestamp, and you can just add a >> new code to the format string that to_timestamp understands, ie 'e' or >> something or 'u' that means 'unix time

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

2004-08-14 Thread Michael Glaesemann
On Aug 14, 2004, at 6:50 PM, Christopher Kings-Lynne wrote: Maybe you don't need to override to_timestamp, and you can just add a new code to the format string that to_timestamp understands, ie 'e' or something or 'u' that means 'unix timestamp'? Thanks for looking at the code! I know people are

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

2004-08-14 Thread Christopher Kings-Lynne
I wonder... Maybe you don't need to override to_timestamp, and you can just add a new code to the format string that to_timestamp understands, ie 'e' or something or 'u' that means 'unix timestamp'? Chris Michael Glaesemann wrote: Please find attached a patch (diff -c against cvs HEAD) to add a