Re: Selecting newly added column returns empty but only when selecting with other columns in table - Mailing list pgsql-general

On 11/26/2015 4:13 PM, mrtruji wrote:
>
> Just added a new bytea type column to an existing psql table and
> populated the column entirely with row data. Running into some strange
> query results:
>
> When I select the newly added column by itself I get all the data as
> expected:.....
>

can you show the SQL commands you used to add this column and populate
it?   if you used INSERT to populate the new column, that would have
inserted NEW rows, not modified existing rows.  to modify the existing
rows, you need to use UPDATE with a WHERE clause that selects the
correct row to UPDATE with the data for your new field...



--
john r pierce, recycling bits in santa cruz