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...
