Re: pgsql: doc: add examples of creative use of unique expression indexes

2020-04-10 Thread Bruce Momjian
On Fri, Apr 10, 2020 at 07:21:29PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > I agree with your analysis. I still want to have some mention that > > partial indexes can be used to create single-NULL columns, which might > > be required for compatibility with other databases. Attached is

Re: pgsql: doc: add examples of creative use of unique expression indexes

2020-04-10 Thread Tom Lane
Bruce Momjian writes: > I agree with your analysis. I still want to have some mention that > partial indexes can be used to create single-NULL columns, which might > be required for compatibility with other databases. Attached is an > updated patch which removes the previous commit but adds a me

Re: pgsql: doc: add examples of creative use of unique expression indexes

2020-04-10 Thread Bruce Momjian
On Fri, Apr 10, 2020 at 11:30:34AM -0400, Tom Lane wrote: > Bruce Momjian writes: > > doc: add examples of creative use of unique expression indexes > > https://git.postgresql.org/pg/commitdiff/a9760d0f3cb523336b5fdd9d6c5985e39a8588a1 > > We had a complaint [1] that this dropped an example into

Re: pgsql: doc: add examples of creative use of unique expression indexes

2020-04-10 Thread Tom Lane
Bruce Momjian writes: > doc: add examples of creative use of unique expression indexes > https://git.postgresql.org/pg/commitdiff/a9760d0f3cb523336b5fdd9d6c5985e39a8588a1 We had a complaint [1] that this dropped an example into the middle of two related paragraphs. I agree with that objection,

pgsql: doc: add examples of creative use of unique expression indexes

2019-12-27 Thread Bruce Momjian
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/[email protected] Backpatch-through: 9.4

pgsql: doc: add examples of creative use of unique expression indexes

2019-12-27 Thread Bruce Momjian
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/[email protected] Backpatch-through: 9.4

pgsql: doc: add examples of creative use of unique expression indexes

2019-12-27 Thread Bruce Momjian
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/[email protected] Backpatch-through: 9.4

pgsql: doc: add examples of creative use of unique expression indexes

2019-12-27 Thread Bruce Momjian
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/[email protected] Backpatch-through: 9.4

pgsql: doc: add examples of creative use of unique expression indexes

2019-12-27 Thread Bruce Momjian
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/[email protected] Backpatch-through: 9.4

pgsql: doc: add examples of creative use of unique expression indexes

2019-12-27 Thread Bruce Momjian
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/[email protected] Backpatch-through: 9.4

pgsql: doc: add examples of creative use of unique expression indexes

2019-12-27 Thread Bruce Momjian
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/[email protected] Backpatch-through: 9.4