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:
SELECT new_col FROM data LIMIT 1;
Result: \x8481e7dec3650040b
hen restrict to only 1 row.
> Have you tried with no limit? IE: SELECT new_col FROM data;
>
>
> On Thu, Nov 26, 2015 at 7: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 in
xrelid = i.indexrelid )
> WHERE idx.indisvalid = FALSE
>AND i.relname = 'data'
> ORDER BY 1, 2,3;
>
> On Thu, Nov 26, 2015 at 9:10 PM, mrtruji wrote:
>
>> Hi,
>>
>> Thanks for the reply. The limit is just to simplify results for the
>> examples. T
wrote:
> On 11/26/2015 06:10 PM, mrtruji wrote:
>
>> Hi,
>>
>> Thanks for the reply. The limit is just to simplify results for the
>> examples. The same behavior occurs when each of the three queries are
>> not limited. Whenever I try to filter by the original
96
(1 row)
On Thu, Nov 26, 2015 at 6:55 PM, Adrian Klaver
wrote:
> On 11/26/2015 06:10 PM, mrtruji wrote:
>
>> Hi,
>>
>> Thanks for the reply. The limit is just to simplify results for the
>> examples. The same behavior occurs when each of the three queries are
>>
y array objects.
On Thu, Nov 26, 2015 at 7:04 PM, John R Pierce wrote:
> 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 r
On Thu, Nov 26, 2015 at 7:24 PM, Melvin Davidson
wrote:
> Look like another case of PEBKAC solved. Thanks Adrian & JOhn for the
> assist. Happy Thanksgiving everyone.
>
> On Thu, Nov 26, 2015 at 10:22 PM, John R Pierce
> wrote:
>
>> On 11/26/2015 7:08 PM, mrtr
