I was recently surprised to find that EXTRACT's day of the week numbering is different than TO_CHAR's ditto. EXTRACT starts at 0==Sunday while TO_CHAR starts at 1==Sunday.
I was recently surprised to find that EXTRACT's day of the week
numbering is different than TO_CHAR's ditto. EXTRACT starts at 0==Sunday
while TO_CHAR starts at 1==Sunday.

A suggestion for two documentation notes is attached as a patch to
current CVS HEAD.

Troels Arvin

cjcjameson/gpdb,yuanzhao/gpdb,rubikloud/gpdb,foyzur/gpdb,CraigHarris/gpdb,atris/gpdb,arcivanov/postgres-xl,lpetrov-pivotal/gpdb,Quikling/gpdb,xuegang/gpdb,kmjungersen/PostgresXL,adam8157/gpdb,50wu/gpdb,postmind-net/postgres-xl,jmcatamney/gpdb,50wu/gpdb,lintzc/gpdb,zaksoup/gpdb,greenplum-db/gpdb,atris/gpdb,ovr/postgres-xl,yuanzhao/gpdb,tpostgres-projects/tPostgres,jmcatamney/gpdb,lpetrov-pivotal/gpdb,lintzc/gpdb,xinzweb/gpdb,zeroae/postgres-xl,kaknikhil/gpdb,0x0FFF/gpdb,xinzweb/gpdb,ovr/postgres-xl,royc1/gpdb,yuanzhao/gpdb,janebeckman/gpdb,CraigHarris/gpdb,yazun/postgres-xl,rvs/gpdb,ashwinstar/gpdb,royc1/gpdb,arcivanov/postgres-xl,greenplum-db/gpdb,ashwinstar/gpdb,foyzur/gpdb,adam8157/gpdb,jmcatamney/gpdb,janebeckman/gpdb,yazun/postgres-xl,lisakowen/gpdb,janebeckman/gpdb,foyzur/gpdb,edespino/gpdb,cjcjameson/gpdb,zeroae/postgres-xl,postmind-net/postgres-xl,zaksoup/gpdb,lintzc/gpdb,techdragon/Postgres-XL,zaksoup/gpdb,xuegang/gpdb,0x0FFF/gpdb,yuanzhao/gpdb,royc1/gpdb,kmjungersen/PostgresXL,ahachete/gpdb,Postgres-XL/Postgres-XL,tpostgres-projects/tPostgres,postmind-net/postgres-xl,0x0FFF/gpdb,arcivanov/postgres-xl,50wu/gpdb,50wu/gpdb,pavanvd/postgres-xl,pavanvd/postgres-xl,Quikling/gpdb,edespino/gpdb,xinzweb/gpdb,yuanzhao/gpdb,adam8157/gpdb,techdragon/Postgres-XL,edespino/gpdb,randomtask1155/gpdb,50wu/gpdb,Chibin/gpdb,adam8157/gpdb,kaknikhil/gpdb,ahachete/gpdb,kaknikhil/gpdb,janebeckman/gpdb,ahachete/gpdb,techdragon/Postgres-XL,zaksoup/gpdb,foyzur/gpdb,royc1/gpdb,tangp3/gpdb,Chibin/gpdb,ashwinstar/gpdb,kmjungersen/PostgresXL,chrishajas/gpdb,CraigHarris/gpdb,50wu/gpdb,rubikloud/gpdb,rvs/gpdb,CraigHarris/gpdb,jmcatamney/gpdb,arcivanov/postgres-xl,yazun/postgres-xl,atris/gpdb,snaga/postgres-xl,ashwinstar/gpdb,tangp3/gpdb,oberstet/postgres-xl,ovr/postgres-xl,xuegang/gpdb,tpostgres-projects/tPostgres,Postgres-XL/Postgres-XL,kmjungersen/PostgresXL,arcivanov/postgres-xl,adam8157/gpdb,Chibin/gpdb,randomtask1155/gpdb,Quikling/gpdb,greenplum-db/gpdb,randomtask1155/gpdb,Chibin/gpdb,cjcjameson/gpdb,janebeckman/gpdb,tangp3/gpdb,lpetrov-pivotal/gpdb,tangp3/gpdb,royc1/gpdb,rubikloud/gpdb,greenplum-db/gpdb,edespino/gpdb,atris/gpdb,ovr/postgres-xl,jmcatamney/gpdb,Quikling/gpdb,lintzc/gpdb,lisakowen/gpdb,jmcatamney/gpdb,lpetrov-pivotal/gpdb,tangp3/gpdb,0x0FFF/gpdb,tangp3/gpdb,pavanvd/postgres-xl,greenplum-db/gpdb,edespino/gpdb,randomtask1155/gpdb,zeroae/postgres-xl,rvs/gpdb,xuegang/gpdb,arcivanov/postgres-xl,royc1/gpdb,rubikloud/gpdb,janebeckman/gpdb,snaga/postgres-xl,chrishajas/gpdb,lisakowen/gpdb,xinzweb/gpdb,foyzur/gpdb,rvs/gpdb,0x0FFF/gpdb,Chibin/gpdb,randomtask1155/gpdb,tangp3/gpdb,Quikling/gpdb,foyzur/gpdb,rubikloud/gpdb,Postgres-XL/Postgres-XL,adam8157/gpdb,lisakowen/gpdb,atris/gpdb,kaknikhil/gpdb,CraigHarris/gpdb,rvs/gpdb,lisakowen/gpdb,ovr/postgres-xl,yuanzhao/gpdb,Chibin/gpdb,yuanzhao/gpdb,tpostgres-projects/tPostgres,CraigHarris/gpdb,rvs/gpdb,xinzweb/gpdb,ashwinstar/gpdb,atris/gpdb,ahachete/gpdb,kaknikhil/gpdb,kaknikhil/gpdb,adam8157/gpdb,ashwinstar/gpdb,randomtask1155/gpdb,ashwinstar/gpdb,zeroae/postgres-xl,lintzc/gpdb,atris/gpdb,ashwinstar/gpdb,lintzc/gpdb,lintzc/gpdb,50wu/gpdb,Quikling/gpdb,xinzweb/gpdb,foyzur/gpdb,janebeckman/gpdb,lintzc/gpdb,xinzweb/gpdb,ahachete/gpdb,foyzur/gpdb,rvs/gpdb,cjcjameson/gpdb,CraigHarris/gpdb,randomtask1155/gpdb,cjcjameson/gpdb,edespino/gpdb,lpetrov-pivotal/gpdb,edespino/gpdb,randomtask1155/gpdb,lisakowen/gpdb,Chibin/gpdb,oberstet/postgres-xl,xuegang/gpdb,rvs/gpdb,yuanzhao/gpdb,rubikloud/gpdb,zaksoup/gpdb,lintzc/gpdb,ahachete/gpdb,yuanzhao/gpdb,lpetrov-pivotal/gpdb,ahachete/gpdb,jmcatamney/gpdb,pavanvd/postgres-xl,lpetrov-pivotal/gpdb,postmind-net/postgres-xl,Chibin/gpdb,royc1/gpdb,Postgres-XL/Postgres-XL,greenplum-db/gpdb,yuanzhao/gpdb,cjcjameson/gpdb,kaknikhil/gpdb,snaga/postgres-xl,adam8157/gpdb,cjcjameson/gpdb,rubikloud/gpdb,zaksoup/gpdb,tangp3/gpdb,greenplum-db/gpdb,techdragon/Postgres-XL,CraigHarris/gpdb,Chibin/gpdb,janebeckman/gpdb,Quikling/gpdb,xuegang/gpdb,Quikling/gpdb,tpostgres-projects/tPostgres,kmjungersen/PostgresXL,cjcjameson/gpdb,yazun/postgres-xl,atris/gpdb,yazun/postgres-xl,xuegang/gpdb,rubikloud/gpdb,Quikling/gpdb,0x0FFF/gpdb,0x0FFF/gpdb,kaknikhil/gpdb,chrishajas/gpdb,zaksoup/gpdb,oberstet/postgres-xl,Chibin/gpdb,ahachete/gpdb,Quikling/gpdb,chrishajas/gpdb,snaga/postgres-xl,rvs/gpdb,chrishajas/gpdb,oberstet/postgres-xl,greenplum-db/gpdb,xuegang/gpdb,chrishajas/gpdb,jmcatamney/gpdb,0x0FFF/gpdb,cjcjameson/gpdb,kaknikhil/gpdb,edespino/gpdb,xuegang/gpdb,janebeckman/gpdb,techdragon/Postgres-XL,pavanvd/postgres-xl,lisakowen/gpdb,50wu/gpdb,CraigHarris/gpdb,rvs/gpdb,oberstet/postgres-xl,lpetrov-pivotal/gpdb,chrishajas/gpdb,Postgres-XL/Postgres-XL,edespino/gpdb,chrishajas/gpdb,postmind-net/postgres-xl,edespino/gpdb,zeroae/postgres-xl,kaknikhil/gpdb,cjcjameson/gpdb,snaga/postgres-xl,royc1/gpdb,xinzweb/gpdb,janebeckman/gpdb,lisakowen/gpdb,zaksoup/gpdb