Horton

Re: EXCLUDE COLLATE in CREATE/ALTER TABLE document

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: shihao zhong <zhong950419@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2023-11-01T01:07:11Z
Lists: pgsql-hackers 
shihao zhong <zhong950419@gmail.com> writes:
> I noticed that the CREATE/ALTER TABLE document does not mention that
> EXCLUDE can accept a collation. I created a documentation fix for this
> issue, and I have attached it to this email.

Hmm ... is this actually correct?  I think that the collate
option has to come before the opclass name etc, so you'd need
to shove it into exclude_element to provide an accurate
description of the syntax.

			regards, tom lane

Commits

  1. Doc: update documentation about EXCLUDE constraint elements.