Re: text and varchar are not equivalent - Mailing list pgsql-docs

From David G. Johnston
Subject Re: text and varchar are not equivalent
Date
Msg-id CAKFQuwbUeWu8fp5J1FW2vBn8-5RGnVS+Jtdri38HJbYT+VLPmA@mail.gmail.com
Whole thread Raw
In response to text and varchar are not equivalent  (PG Doc comments form <noreply@postgresql.org>)
Responses Re: text and varchar are not equivalent
List pgsql-docs
On Fri, Feb 9, 2024, 10:12 PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/datatype-character.html
Description:

The documentation implies that the data types text and varchar are
equivalent, but this is not the case with this test in Postgresql version
16.

Fair point.  But I'd rather further emphasize that char should just be avoided so this and other unexpected outcomes simply do not manifest in a real database scenario.  Rather than try and document how odd it's behavior is when dealing with intra-textual type conversions.

David J.


pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: text and varchar are not equivalent
Next
From: Tom Lane
Date:
Subject: Re: text and varchar are not equivalent