Revision 1248
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 4659 | 4659 |
-- Name: party_unique_name; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4660 | 4660 |
-- |
| 4661 | 4661 |
|
| 4662 |
CREATE UNIQUE INDEX party_unique_name ON party USING btree ((COALESCE(givenname, ''::text)), (COALESCE(middlename, ''::text)), (COALESCE(surname, ''::text)), (COALESCE(organizationname, ''::text)));
|
|
| 4662 |
CREATE UNIQUE INDEX party_unique_name ON party USING btree (givenname, (COALESCE(middlename, ''::text)), surname);
|
|
| 4663 | 4663 |
|
| 4664 | 4664 |
|
| 4665 | 4665 |
-- |
Also available in: Unified diff
vegbien.sql: party: Changed party_unique_name to ignore NULL values and the organizationname (a first(+middle)+last name is considered unique)