Re: CHAR or VARCHAR

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: CHAR or VARCHAR
Дата
Msg-id Pine.BSF.4.21.0103220927210.41849-100000@megazone23.bigpanda.com
обсуждение исходный текст
Ответ на Re: CHAR or VARCHAR  (Karel Zak <zakkr@zf.jcu.cz>)
Список pgsql-sql
On Thu, 22 Mar 2001, Karel Zak wrote:

> On Thu, Mar 22, 2001 at 08:05:19AM -0300, Martin A. Marques wrote:
> > >
> > > In 7.1(currently in beta), long values can be stored
> > > outside that so you have more of a number of columns
> > > limit rather than a per value limit.  Technically,
> > > it's probably still not a great idea to be sticking
> > > megs in there for performance reasons.
> > 
> > I can't believe that there is no limit. You mean that I put this:
> > 
> > VARCHAR(1000000000000000000000000000000000)
> 
>  ...length for type 'varchar' cannot exceed 10485760.
>  
>  But "no limit" means 'text'.

True, but in a practical sense, even 10M or so is probably
pushing your luck unless you've got alot of ram.



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

Предыдущее
От: Jason Earl
Дата:
Сообщение: Re: Birthday search.
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Foreign key referencing subclasses.