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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
