| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: doc: add examples of creative use of unique expression indexes |
| Date: | 2019-12-27 19:49:17 |
| Message-ID: | E1ikvbp-0005jW-E9@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-docs |
doc: add examples of creative use of unique expression indexes
Unique expression indexes can constrain data in creative ways, so show
two examples.
Reported-by: Tuomas Leikola
Discussion: https://postgr.es/m/156760275564.1127.12321702656456074572@wrigleys.postgresql.org
Backpatch-through: 9.4
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/a9760d0f3cb523336b5fdd9d6c5985e39a8588a1
Modified Files
--------------
doc/src/sgml/indices.sgml | 19 +++++++++++++++++++
1 file changed, 19 insertions(+)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2019-12-27 21:35:31 | pgsql: Add pg_dump test for triggers on partitioned tables |
| Previous Message | Bruce Momjian | 2019-12-27 19:33:39 | pgsql: docs: clarify infinite range values from data-type infinities |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2019-12-27 19:49:27 | Re: uniqueness and null could benefit from a hint for dba |
| Previous Message | Bruce Momjian | 2019-12-27 19:33:59 | Re: Why 'infinity' is not in range '[2019-01-02, infinity]'? |