Re: [PATCHES] Interval Patch

2003-06-25 Thread Bruce Momjian

Tom has applied a fix for this.

---

Larry Rosenman wrote:
> This is against 7.3.3 sources, but it fixes the TODO
> * Have SELECT '13 minutes'::interval display zero seconds in ISO
> datestyle
> 
> *** datetime.c.orig   Sat May  3 23:30:35 2003
> --- datetime.cTue Jun 24 15:54:39 2003
> ***
> *** 3498,3504 
>   is_nonzero = TRUE;
>   }
>   /* otherwise, integer seconds only? */
> ! else if (tm->tm_sec != 0)
>   {
>   sprintf(cp, ":%02d", abs(tm->tm_sec));
>   cp += strlen(cp);
> --- 3498,3504 
>   is_nonzero = TRUE;
>   }
>   /* otherwise, integer seconds only? */
> ! else
>   {
>   sprintf(cp, ":%02d", abs(tm->tm_sec));
>   cp += strlen(cp);
> 
> -- 
> Larry Rosenman http://www.lerctr.org/~ler
> Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED]
> US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
> 
> 

[ Attachment, skipping... ]

> 
> ---(end of broadcast)---
> TIP 9: the planner will ignore your desire to choose an index scan if your
>   joining column's datatypes do not match

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


Re: [PATCHES] Interval Patch

2003-06-25 Thread Tom Lane
Larry Rosenman <[EMAIL PROTECTED]> writes:
> This is against 7.3.3 sources, but it fixes the TODO
> * Have SELECT '13 minutes'::interval display zero seconds in ISO
> datestyle

Applied to CVS tip, along with requisite regression test updates.
I'm unwilling to apply to 7.3 branch though, since it's a definitional
change rather than a true bug.

regards, tom lane

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match