diff -c -r postgresql-7.1.3.org/src/backend/utils/adt/datetime.c postgresql-7.1.3/src/backend/utils/adt/datetime.c
*** postgresql-7.1.3.org/src/backend/utils/adt/datetime.c	Fri May  4 00:53:07 2001
--- postgresql-7.1.3/src/backend/utils/adt/datetime.c	Sat Sep  8 11:51:35 2001
***************
*** 317,325 ****
--- 317,327 ----
  										 * units */
  	{"w", UNITS, DTK_WEEK},		/* "week" relative time units */
  	{DWEEK, UNITS, DTK_WEEK},	/* "week" relative time units */
+         {"weekday", UNITS, DTK_WEEKDAY}, /* "weekday" day since sunday */
  	{"weeks", UNITS, DTK_WEEK}, /* "weeks" relative time units */
  	{"y", UNITS, DTK_YEAR},		/* "year" relative time units */
  	{DYEAR, UNITS, DTK_YEAR},	/* "year" relative time units */
+         {"yearday", UNITS, DTK_YEARDAY}, /* "yearday" day since jan. 1 */
  	{"years", UNITS, DTK_YEAR}, /* "years" relative time units */
  	{"yr", UNITS, DTK_YEAR},	/* "year" relative time units */
  	{"yrs", UNITS, DTK_YEAR},	/* "years" relative time units */
diff -c -r postgresql-7.1.3.org/src/backend/utils/adt/timestamp.c postgresql-7.1.3/src/backend/utils/adt/timestamp.c
*** postgresql-7.1.3.org/src/backend/utils/adt/timestamp.c	Fri May  4 00:53:07 2001
--- postgresql-7.1.3/src/backend/utils/adt/timestamp.c	Sat Sep  8 12:13:30 2001
***************
*** 341,346 ****
--- 341,354 ----
  #endif
  			tm->tm_isdst = tx->tm_isdst;
  
+ /*
+  * wday contains the day of week since sunday [0-6]
+  * yday contains the day of year sinye jan. 1 [0-365]
+  */
+  
+  			tm->tm_wday = tx->tm_wday;
+  			tm->tm_yday = tx->tm_yday;
+  			
  #if defined(HAVE_TM_ZONE)
  			tm->tm_gmtoff = tx->tm_gmtoff;
  			tm->tm_zone = tx->tm_zone;
***************
*** 1933,1938 ****
--- 1941,1952 ----
  
  				case DTK_MILLENNIUM:
  					result = (tm->tm_year / 1000);
+ 					break;
+ 				case DTK_WEEKDAY:
+ 					result = (tm->tm_wday);
+ 					break;
+ 				case DTK_YEARDAY:
+ 					result = (tm->tm_yday);
  					break;
  
  				default:
diff -c -r postgresql-7.1.3.org/src/include/utils/datetime.h postgresql-7.1.3/src/include/utils/datetime.h
*** postgresql-7.1.3.org/src/include/utils/datetime.h	Fri May  4 00:53:07 2001
--- postgresql-7.1.3/src/include/utils/datetime.h	Sat Sep  8 11:32:15 2001
***************
*** 154,159 ****
--- 154,162 ----
  #define DTK_TZ_HOUR		34
  #define DTK_TZ_MINUTE	35
  
+ #define DTK_WEEKDAY	36
+ #define DTK_YEARDAY	37
+ 
  /*
   * Bit mask definitions for time parsing.
   */