Re: [SQL] Maybe a Bug, maybe bad SQL

2001-03-21 Thread Tom Lane
[EMAIL PROTECTED] (D'Arcy J.M. Cain) writes: > Thus spake Grant >> Why does everyone reply to the person as well as CC to the list when the >> person is on the list anyhow? > Politeness. You reply to the list so that others benefit from the discussion > and you copy the sender since some people

Re: [SQL] Maybe a Bug, maybe bad SQL

2001-03-21 Thread Cedar Cox
> > 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. A

Re: [SQL] Maybe a Bug, maybe bad SQL

2001-03-21 Thread Ross J. Reedstrom
On Wed, Mar 21, 2001 at 08:20:22AM -0500, Bruce Momjian wrote: > > 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_d

Re: [SQL] Maybe a Bug, maybe bad SQL

2001-03-21 Thread Bruce Momjian
> Note also that it's a mailing list cultural thing: many lists operate > in a 'post only to the list' mode. Those of us on the pgsql lists do the > 'list and person' thing, in response to direct questions, for the reasons > Bruce and D'Arcy point out. Note that by knowing the reasons, one may > t

Re: [SQL] Maybe a Bug, maybe bad SQL

2001-03-21 Thread Bruce Momjian
> 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 >

Re: [SQL] Maybe a Bug, maybe bad SQL

2001-03-21 Thread D'Arcy J.M. Cain
Thus spake Grant > Why does everyone reply to the person as well as CC to the list when the > person is on the list anyhow? Politeness. You reply to the list so that others benefit from the discussion and you copy the sender since some people don't get to their mailing lists as quickly as their

Re: [SQL] Maybe a Bug, maybe bad SQL

2001-03-20 Thread Tom Lane
Daryl Herzmann <[EMAIL PROTECTED]> writes: > akrherz=# create table test (day date); > CREATE > akrherz=# insert into test values('2000_04_02'); > INSERT 13166281 1 > akrherz=# insert into test values('2000_04_01'); > INSERT 13166282 1 > akrherz=# insert into test values('2000_04_03'); > INSERT 13

Re: [SQL] Maybe a Bug, maybe bad SQL

2001-03-20 Thread Grant
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 anyho

Re: [SQL] Maybe a Bug, maybe bad SQL

2001-03-20 Thread Bruce Momjian
With 7.1beta, I get: day | day +- 2000-04-02 | 2 2000-04-01 | 1 2000-04-03 | 3 (3 rows) > HI, > I am running postgres version 7.0 and I do this... > > akrherz=# create table test (day date); > CREATE

[SQL] Maybe a Bug, maybe bad SQL

2001-03-20 Thread Daryl Herzmann
HI, I am running postgres version 7.0 and I do this... akrherz=# create table test (day date); CREATE akrherz=# insert into test values('2000_04_02'); INSERT 13166281 1 akrherz=# insert into test values('2000_04_01'); INSERT 13166282 1 akrherz=# insert into test values('2000_04_03'); INSE