doc: Clarify that empty COMMENT string removes the comment. Clarify the documentation of COMMENT ON to state that specifying an empty string is treated as NULL, meaning that the comment is removed.
This makes the behavior explicit and avoids possible confusion about how empty strings are handled. Also adds regress test cases that use empty string to remove a comment. Backpatch to all supported versions. Author: Chao Li <[email protected]> Reviewed-by: Ashutosh Bapat <[email protected]> Reviewed-by: David G. Johnston <[email protected]> Reviewed-by: Shengbin Zhao <[email protected]> Reviewed-by: Jim Jones <[email protected]> Reviewed-by: zhangqiang <[email protected]> Reviewed-by: Fujii Masao <[email protected]> Discussion: https://postgr.es/m/[email protected] Backpatch-through: 14 Branch ------ REL_16_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/228addbbf2c13f8cc8f80bb6f0aa5bd7204e65e5 Modified Files -------------- doc/src/sgml/ref/comment.sgml | 18 +++++++++++------- src/test/regress/expected/create_index.out | 14 ++++++++++++++ src/test/regress/expected/create_role.out | 27 +++++++++++++++++++++++++++ src/test/regress/sql/create_index.sql | 4 ++++ src/test/regress/sql/create_role.sql | 7 +++++++ 5 files changed, 63 insertions(+), 7 deletions(-)
