Re: text vs varchar(n)
От
Einar Karttunen
Тема
Re: text vs varchar(n)
Дата
Msg-id
20020218055439.GB6129@shellak.helsinki.fi
Ответ на
text vs varchar(n) (Richard Emberson)
Список
Дерево обсуждения
text vs varchar(n) Richard Emberson <emberson@phc.net>
Re: text vs varchar(n) Einar Karttunen <ekarttun@cs.helsinki.fi>
Re: text vs varchar(n) "Robert Treat" <robertt@auctionsolutions.com>
Re: text vs varchar(n) Einar Karttunen <ekarttun@cs.helsinki.fi>
Re: text vs varchar(n) Tom Lane <tgl@sss.pgh.pa.us>
Re: text vs varchar(n) Jean-Michel POURE <jm.poure@freesurf.fr>
On 17.02.02 21:52 -0800(+0000), Richard Emberson wrote: > Which is faster read and write, a table with text or varchar types: > > ... > > Why would one every use varchar(n) instead of text (aside from non-sql > standard)? > Varchar(n) and text have the same performance. The difference is that varchars are silently cut if they are longer than the limit specified. In most cases you want to stick with text. - Einar Karttunen
В списке pgsql-general по дате отправления
