Entered data appears TWICE in table!!? - Mailing list pgsql-sql

From rmorgan7@austin.rr.com (Ron M.)
Subject Entered data appears TWICE in table!!?
Date
Msg-id d7fc3008.0403301129.22a499c9@posting.google.com
Whole thread Raw
Responses Re: Entered data appears TWICE in table!!?  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-sql
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.


pgsql-sql by date:

Previous
From: "Bulatovic Natasa"
Date:
Subject: Re: Invalid Unicode Character Sequence found
Next
From: Kyle
Date:
Subject: Simple insert not returning