Received: from candle.pha.pa.us (candle.navpoint.com [162.33.245.46]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2LDKbt83423 for ; Wed, 21 Mar 2001 08:20:37 -0500 (EST) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id IAA14294; Wed, 21 Mar 2001 08:20:22 -0500 (EST) From: Bruce Momjian Message-Id: <200103211320.IAA14294@candle.pha.pa.us> Subject: Re: Maybe a Bug, maybe bad SQL In-Reply-To: "from Grant at Mar 21, 2001 03:27:36 pm" To: Grant Date: Wed, 21 Mar 2001 08:20:22 -0500 (EST) CC: pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL77 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200103/414 X-Sequence-Number: 2082 > version 7.0.3 > > binary_data=# select day, date_part('day', day) AS day from test; > day | day > ------------+----- > 02/04/2000 | 2 > 01/04/2000 | 1 > 03/04/2000 | 3 > (3 rows) > > binary_data=# > > Why does everyone reply to the person as well as CC to the list when the > person is on the list anyhow? Good question. They get the reply faster by sending it to them and the list, and if someone later wants to reply only to the poster, they have the email address right there. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026