Skip site navigation (1) Skip section navigation (2)

Re: datatypes: text vs varchar

From: Neil Conway <neilc(at)samurai(dot)com>
To: Ruslan A Dautkhanov <rusland(at)scn(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: datatypes: text vs varchar
Date: 2002-12-08 17:44:27
Message-ID: 1039369467.350.14.camel@tokyo (view raw or flat)
Thread:
Lists: pgsql-bugs
On Sun, 2002-12-08 at 08:28, Ruslan A Dautkhanov wrote:
>     Hello,
> 
>     Can anybody tell us - how much 'text' datatype harder for
>     database vs 'varchar(xx)' datatype?

http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/datatype-character.html

>From that page: "Tip:  There are no performance differences between
these three types, apart from the increased storage size when using the
blank-padded type."

Cheers,

Neil
-- 
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC




In response to

pgsql-bugs by date

Next:From: Rafael FernandezDate: 2002-12-08 23:09:10
Subject: Can't start postgresql
Previous:From: Gerhard HäringDate: 2002-12-08 17:12:13
Subject: Re: 7.3 RMPS bugs ( pgdb.py and postgresql launch script )

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group