Re: text .vs. varchar

In response to Joao Ferreira <jmcferreira(at)critical-links(dot)com>:

> Hello all,
>
> I have a big database in which much information is stored in TEXT type
> columns (I did this initially because I did not want to limit the
> maximum size of the string to be stored)... but...
>
> .. let's say I choose an upper limit (p.ex. 200) for the string sizes
> and I start a fresh database with VARCHAR(200).
>
> What tradeoffs can I expect ? disk usage ? query execution times ?

See the "Tip" on this page, it answers your questions:
http://www.postgresql.org/docs/8.3/static/datatype-character.html

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran(at)collaborativefusion(dot)com
Phone: 412-422-3463x4023