Re: Entered data appears TWICE in table!!?

From: Jeff Eckermann <jeff_eckermann(at)yahoo(dot)com>
To: "Ron M(dot)" <rmorgan7(at)austin(dot)rr(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Entered data appears TWICE in table!!?
Date: 2004-04-05 22:33:02
Message-ID: 20040405223302.58808.qmail@web20806.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

What interface are you using?

--- "Ron M." <rmorgan7(at)austin(dot)rr(dot)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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-04-05 22:34:21 Re: group by not returning sorted rows
Previous Message Bret Hughes 2004-04-05 21:55:42 group by not returning sorted rows