Re: [HACKERS] interval's and printing...

2003-06-24 Thread Larry Rosenman
--On Tuesday, June 24, 2003 14:43:24 -0400 Bruce Momjian <[EMAIL PROTECTED]> wrote: TODO updated: * Have SELECT '13 minutes'::interval display zero seconds in ISO datestyle I just posted a patch to -patches for this. (it's a quickie, even). -- Larry Rosenman

Re: [HACKERS] interval's and printing...

2003-06-24 Thread Bruce Momjian
TODO updated: * Have SELECT '13 minutes'::interval display zero seconds in ISO datestyle --- Larry Rosenman wrote: > > > --On Tuesday, June 24, 2003 10:44:25 -0400 Bruce Momjian > <[EMAIL PROTECTED]> w

Re: [HACKERS] interval's and printing...

2003-06-24 Thread Larry Rosenman
--On Tuesday, June 24, 2003 10:44:25 -0400 Bruce Momjian <[EMAIL PROTECTED]> wrote: Larry Rosenman wrote: >> > * Have SELECT '13 minutes'::interval display zero seconds >> you might want to clarify the TODO to include in ISO DateStyle. >> >> (Per tom's comments). > > Can you supply an example

Re: [HACKERS] interval's and printing...

2003-06-24 Thread Bruce Momjian
Larry Rosenman wrote: > >> > * Have SELECT '13 minutes'::interval display zero seconds > >> you might want to clarify the TODO to include in ISO DateStyle. > >> > >> (Per tom's comments). > > > > Can you supply an example/text? > * Have SELECT '13 minutes'::interval display zero seconds when using

Re: [HACKERS] interval's and printing...

2003-06-24 Thread Larry Rosenman
--On Tuesday, June 24, 2003 09:46:33 -0400 Bruce Momjian <[EMAIL PROTECTED]> wrote: Larry Rosenman wrote: > > Add to TODO: > >* Have SELECT '13 minutes'::interval display zero seconds you might want to clarify the TODO to include in ISO DateStyle. (Per tom's comments). Can you supply an exa

Re: [HACKERS] interval's and printing...

2003-06-24 Thread Bruce Momjian
Larry Rosenman wrote: > > > > Add to TODO: > > > > * Have SELECT '13 minutes'::interval display zero seconds > you might want to clarify the TODO to include in ISO DateStyle. > > (Per tom's comments). Can you supply an example/text? -- Bruce Momjian| http://candle

Re: [HACKERS] interval's and printing...

2003-06-24 Thread Larry Rosenman
--On Monday, June 23, 2003 23:41:29 -0400 Bruce Momjian <[EMAIL PROTECTED]> wrote: Add to TODO: * Have SELECT '13 minutes'::interval display zero seconds you might want to clarify the TODO to include in ISO DateStyle. (Per tom's comments). LER -- Larry Rosenman http:/

Re: [HACKERS] interval's and printing...

2003-06-23 Thread Bruce Momjian
Add to TODO: * Have SELECT '13 minutes'::interval display zero seconds --- Larry Rosenman wrote: > Why does the interval type not print seconds when they are zero? > > This leads to inconsistent reading of the inf

Re: [HACKERS] interval's and printing...

2003-06-22 Thread Bruce Momjian
Tom Lane wrote: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > Why does the interval type not print seconds when they are zero? > > Seems like a bug to me too. Anyone think it's not? > > Note this only occurs with DateStyle = ISO, the other datestyles > use a different format for intervals. C

Re: [HACKERS] interval's and printing...

2003-06-21 Thread Tom Lane
Larry Rosenman <[EMAIL PROTECTED]> writes: > Why does the interval type not print seconds when they are zero? Seems like a bug to me too. Anyone think it's not? Note this only occurs with DateStyle = ISO, the other datestyles use a different format for intervals. regards

[HACKERS] interval's and printing...

2003-06-21 Thread Larry Rosenman
Why does the interval type not print seconds when they are zero? This leads to inconsistent reading of the information. 7.3.3: ler=# select '13 minutes'::interval; interval -- 00:13 (1 row) ler=# select '13 minutes 1 second'::interval; interval -- 00:13:01 (1 row) ler=# I notice