On Wed, Dec 29, 2010 at 5:04 PM, Jeff Davis wrote:
> On Wed, 2010-12-29 at 16:39 -0800, bricklen wrote:
>> -- works:
>> create unique index t_uidx on t (x desc nulls last,y desc nulls last, z asc);
>> drop index t_uidx;
>
> ...
>
>> -- creating the unique constraint with sorting fails:
>> alter ta
On Wed, 2010-12-29 at 16:39 -0800, bricklen wrote:
> -- works:
> create unique index t_uidx on t (x desc nulls last,y desc nulls last, z asc);
> drop index t_uidx;
...
> -- creating the unique constraint with sorting fails:
> alter table t add constraint t_xyz_uc unique (x desc nulls last,y desc
