>
> The query below returns 3 rows. I presume it is as designed, but i'm
> reporting just to make sure:
>
> recreate table test1 (
> id integer,
> column1 blob sub_type 1 );
>
> insert into test1 values (1, 'asdfg');
> insert into test1 values (2, 'asdfg');
> insert into test1 values (3, 'asdfg');
>
> select distinct
> column1
> from
> test1;
>

Yes, and it's documented in 2.1 release notes under "Sorting on BLOB and ARRAY Columns is Restored" (p.50).
You can cast it to varchar if you want distinct to work, of course you are limited to 32000something characters.

Sasha