On Tue, Nov 5, 2019 at 12:13:06PM -0500, Bruce Momjian wrote:
> On Tue, Oct 29, 2019 at 02:00:38PM +0200, Tuomas Leikola wrote:
> > On Thu, Oct 24, 2019 at 5:31 PM Bruce Momjian wrote:
> >
> > Uh, I am wondering if it is just too details for our docs. Can you
> > think of some text and
On Tue, Oct 29, 2019 at 02:00:38PM +0200, Tuomas Leikola wrote:
> On Thu, Oct 24, 2019 at 5:31 PM Bruce Momjian wrote:
>
> Uh, I am wondering if it is just too details for our docs. Can you
> think of some text and its location?
>
>
>
> "Unique indexes on functions can be used to crea
On Thu, Oct 24, 2019 at 5:31 PM Bruce Momjian wrote:
> Uh, I am wondering if it is just too details for our docs. Can you
> think of some text and its location?
>
>
"Unique indexes on functions can be used to create special types of
constraints, like considering unique values equal (coalesce) or
On Wed, Oct 23, 2019 at 02:35:02PM +0300, Tuomas Leikola wrote:
> That is a nice design. You can create a regular unique index where columns(s)s
> are not null and then filtered index(es) for the cases where some of the
> unique
> columns are null.
>
> However my point, specifically, was that if
That is a nice design. You can create a regular unique index where
columns(s)s are not null and then filtered index(es) for the cases where
some of the unique columns are null.
However my point, specifically, was that if the document in question would
have offered alternative solutions, I personal
On Wed, Sep 4, 2019 at 01:12:35PM +, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/11/indexes-unique.html
> Description:
>
> Sometimes it is convenient to create an unique index that considers NULL
