PostgreSQL创建唯一索引 [英] Postgresql Create Unique Index

问题描述

我想在mobile_number_1和mobile_number_2列上创建唯一索引。

I want to create unique index on mobile_number_1 and mobile_number_2 columns.

通过该方法，mobile_number_1值不会在mobile_number_1和mobile_number_2中重复出现

by which mobile_number_1 values not get repeated in mobile_number_1 as well as in mobile_number_2

和mobile_number_2不在mobile_number_1和mobile_number_2

and mobile_number_2 not get repeated in mobile_number_1 as well as mobile_number_2

我的表结构中重复：

id | mobile_number_1 | mobile_number_2 | city

推荐答案

我认为应该这样做（没有

I think this should do it (haven't tested it thoroughly though)

create unique index idx_unique_mobile_number1
 on person (least(mobile_number_1, mobile_number_2));

create unique index idx_unique_mobile_number2
 on person (greatest(mobile_number_1, mobile_number_2));

这篇关于PostgreSQL创建唯一索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！