Re: text and varchar are not equivalent
| От | David G. Johnston |
|---|---|
| Тема | Re: text and varchar are not equivalent |
| Дата | |
| Msg-id | CAKFQuwbUeWu8fp5J1FW2vBn8-5RGnVS+Jtdri38HJbYT+VLPmA@mail.gmail.com обсуждение исходный текст |
| Ответ на | text and varchar are not equivalent (PG Doc comments form <noreply@postgresql.org>) |
| Ответы |
Re: text and varchar are not equivalent
|
| Список | 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 по дате отправления: