Re: Maximum size for char or varchar with limit

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Maximum size for char or varchar with limit
Дата
Msg-id 4CFFBC65.8090105@gmail.com
обсуждение исходный текст
Ответ на Re: Maximum size for char or varchar with limit  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On 12/08/2010 09:05 AM, Tom Lane wrote:
> Adrian Klaver<adrian.klaver@gmail.com>  writes:
>> On 12/08/2010 08:04 AM, Tom Lane wrote:
>>> The rationale for having a limit of this sort is (a) we *don't* want
>>> the upper limit of declarable length to be encoding-dependent; and
>>> (b) if you are trying to declare an upper limit that's got more than a
>>> few digits in it, you almost certainly ought to not be declaring a limit
>>> at all.ion
>
>> Well that explains it :) Would it be possible to change the below
>> section in the docs to state that the declared max value of n is limited
>> to a max string size of 10Mb?
>
> I don't really see any point in that.  The value is meant to be an order
> of magnitude or so more than anything that's sane according to point (b).
> If you think you need to know what it is, you're already doing it wrong.
>
>             regards, tom lane

Well the determination of sanity is often in the eye of the beholder and
it would be nice to know where the line is. At any rate the answer is
the archives now, so I know where to get it.

--
Adrian Klaver
adrian.klaver@gmail.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Maximum size for char or varchar with limit
Следующее
От: bricklen
Дата:
Сообщение: Re: How to obtain the maximum value of a date, between 3 tables...