Search Postgresql Archives

Re: Add columns to table; insert values based on row

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Add columns to table; insert values based on row
From: Rich Shepard <rshepard@xxxxxxxxxxxxxxx>
Date: Thu, 1 Nov 2018 13:58:12 -0700 (PDT)
In-reply-to: <9acea769-2a99-69a2-beaf-d84834a242b0@aklaver.com>
References: <alpine.LNX.2.20.1811011316280.13759@salmo.appl-ecosys.com> <CAKFQuwb2wshKo4bgbWBr75-Gd_Q7G295FTj5JpYSHXqnPaETuw@mail.gmail.com> <alpine.LNX.2.20.1811011351090.13759@salmo.appl-ecosys.com> <9acea769-2a99-69a2-beaf-d84834a242b0@aklaver.com>
User-agent: Alpine 2.20 (LNX 67 2015-01-07)

On Thu, 1 Nov 2018, Adrian Klaver wrote:

Why? As David said that will get you an additional 82 rows with data that isdissociated from the existing data. You want to update the existing rows withthe new field data for each station.


  D'oh! Of course!

Thanks both,

Rich

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Add columns to table; insert values based on row
  - From: Rich Shepard
- Re: Add columns to table; insert values based on row
  - From: David G. Johnston
- Re: Add columns to table; insert values based on row
  - From: Rich Shepard
- Re: Add columns to table; insert values based on row
  - From: Adrian Klaver

Prev by Date: Re: Truncation of UNLOGGED tables upon restart.
Next by Date: Re: Truncation of UNLOGGED tables upon restart.
Previous by thread: Re: Add columns to table; insert values based on row
Next by thread: Re: Add columns to table; insert values based on row
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux