Re: [GENERAL] question about postgresql time intervals

2006-03-20 Thread Linda
On Friday 17 March 2006 10:20 pm, Michael Glaesemann wrote: > I've been having some email problems, so my apologies if this is a > duplicate. > > On Mar 16, 2006, at 22:49 , Linda wrote: > > > > Thanks for your reply. I guess you missed the original email. I > > have an > > application tha

Re: [GENERAL] question about postgresql time intervals

2006-03-17 Thread Michael Glaesemann
I've been having some email problems, so my apologies if this is a duplicate. On Mar 16, 2006, at 22:49 , Linda wrote: Thanks for your reply. I guess you missed the original email. I have an application that is retrieving "uptime" (an integer number of seconds since reboot) and recasti

Re: [GENERAL] question about postgresql time intervals

2006-03-16 Thread Linda
On Wednesday 15 March 2006 8:13 pm, Tom Lane wrote: > Michael Glaesemann <[EMAIL PROTECTED]> writes: > > On Mar 15, 2006, at 23:39 , Linda wrote: > >> According to the SQL standard, shouldn't this work? > >> > >> select '506:47:04'::interval day to second ; > > > No one has implemented this in Po

Re: [GENERAL] question about postgresql time intervals

2006-03-16 Thread Michael Glaesemann
On Mar 16, 2006, at 10:13 , Tom Lane wrote: But the syntax has been accepted for a long time, at least back to 7.0. Well, look at that! Is this documented? Looks like I should install the DocBook toolchain again. Michael Glaesemann grzm myrealbox com ---(end of

Re: [GENERAL] question about postgresql time intervals

2006-03-15 Thread Tom Lane
Michael Glaesemann <[EMAIL PROTECTED]> writes: > On Mar 15, 2006, at 23:39 , Linda wrote: >> According to the SQL standard, shouldn't this work? >> >> select '506:47:04'::interval day to second ; > No one has implemented this in PostgreSQL yet. It depends on what you define as "work". 8.1 says

Re: [GENERAL] question about postgresql time intervals

2006-03-15 Thread Michael Glaesemann
On Mar 15, 2006, at 23:39 , Linda wrote: According to the SQL standard, shouldn't this work? select '506:47:04'::interval day to second ; No one has implemented this in PostgreSQL yet. Is there a portable way to do this without using justify_hours()? Not currently that I know of. Michae

Re: [GENERAL] question about postgresql time intervals

2006-03-15 Thread Linda
According to the SQL standard, shouldn't this work? select '506:47:04'::interval day to second ; Is there a portable way to do this without using justify_hours()? - Thanks On Tuesday 14 March 2006 6:58 pm, Michael Glaesemann wrote: > You will get better, faster answers by sending questions to a

Re: [GENERAL] question about postgresql time intervals

2006-03-14 Thread Michael Glaesemann
You will get better, faster answers by sending questions to a PostgreSQL mailing list. By emailing me directly you may not get a timely response if I don't have time to answer. Others can then answer and learn from the subsequent discussion. I'm ccing this to pgsql-general. On Mar 15, 200