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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: text and varchar are not equivalent
Следующее
От: Tom Lane
Дата:
Сообщение: Re: text and varchar are not equivalent