Re: diff b/w varchar(N) & text

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: diff b/w varchar(N) & text
Date: 2009-03-17 13:12:04
Message-ID: 49BFA1A4.9000900@sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

sathiya psql wrote:
> Is there any big difference between selecting the data type as
> varchar(N) and text. What is the difference of it when seeing from the
> performance side ?

Check the manual. There is no difference!

http://www.postgresql.org/docs/8.3/static/datatype-character.html

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Srikanth 2009-03-17 14:50:09 SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps
Previous Message sathiya psql 2009-03-17 11:04:16 Re: Exclude fields from SELECT command