X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 5C73ED1E9B8
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  6 Apr 2004 11:26:53 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 62500-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Tue,  6 Apr 2004 11:27:35 -0300 (ADT)
Received: from web20806.mail.yahoo.com (web20806.mail.yahoo.com
	[216.136.226.195])
	by svr1.postgresql.org (Postfix) with SMTP id 2A18BD1DB0E
	for <pgsql-sql@postgresql.org>; Tue,  6 Apr 2004 11:26:47 -0300 (ADT)
Message-ID: <20040406142734.97108.qmail@web20806.mail.yahoo.com>
Received: from [24.248.12.72] by web20806.mail.yahoo.com via HTTP;
	Tue, 06 Apr 2004 07:27:34 PDT
Date: Tue, 6 Apr 2004 07:27:34 -0700 (PDT)
From: Jeff Eckermann <jeff_eckermann@yahoo.com>
Subject: Re: Entered data appears TWICE in table!!?
To: Ron Morgan <rmorgan7@austin.rr.com>
Cc: pgsql-sql@postgresql.org
In-Reply-To: <000c01c41b71$fdd9f2b0$6401a8c0@ron6utw9ter5mr>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200404/34
X-Sequence-Number: 17409

--- Ron Morgan <rmorgan7@austin.rr.com> wrote:
> Both Internet Explorer and Safari, on a Mac running
> OS X.
> 
> I'm just using the tutorial web site at
> sqlcourse.com.  They have a window
> there where you type code and run it, etc.
> 
> Ron
>

I recall doing that tutorial once upon a time.  A very
good thing.

But I don't see the connection to PostgreSQL.  Perhaps
you can explain it?
 
> ----- Original Message ----- 
> From: "Jeff Eckermann" <jeff_eckermann@yahoo.com>
> To: "Ron M." <rmorgan7@austin.rr.com>;
> <pgsql-sql@postgresql.org>
> Sent: Monday, April 05, 2004 5:33 PM
> Subject: Re: [SQL] Entered data appears TWICE in
> table!!?
> 
> 
> > What interface are you using?
> >
> > --- "Ron M." <rmorgan7@austin.rr.com> wrote:
> > > I'm JUST getting started with the online SQL
> > > tutorial at
> > > http://sqlcourse.com.  When I create a table and
> > > insert data, the data
> > > appears TWICE. A simple example:
> > >
> > > ***Create the table:
> > >
> > > create table rnmrgntable
> > > (first varchar(20),
> > > last varchar(30));
> > >
> > > ***Insert data:
> > >
> > > insert into rnmrgntable
> > > (first, last)
> > > values ('Bill' , 'Smith');
> > >
> > > ***Then look at the table:
> > >
> > > select * from rnmrgntable;
> > >
> > > And I get:
> > >
> > > first    last
> > > Bill    Smith
> > > Bill    Smith
> > >
> > > EVERYTHING I enter appears twice, duplicated on
> two
> > > rows as in this
> > > example.  What the heck's going on?
> > >
> > > Ron M.
> > >
> > > ---------------------------(end of
> > > broadcast)---------------------------
> > > TIP 7: don't forget to increase your free space
> map
> > settings
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! Small Business $15K Web Design Giveaway
> > http://promotions.yahoo.com/design_giveaway/
> 
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system
> (http://www.grisoft.com).
> Version: 6.0.644 / Virus Database: 412 - Release
> Date: 3/26/2004
> 


__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway 
http://promotions.yahoo.com/design_giveaway/