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.c Tue 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
datetime.patch
Description: Binary data
---------------------------(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
