Postgres Pro
Downloads
Home   >   mailing lists

Re: diff b/w varchar(N) & text - Mailing list pgsql-sql

From Frank Bax
Subject Re: diff b/w varchar(N) & text
Date
Msg-id 49BFA1A4.9000900@sympatico.ca
Whole thread Raw
In response to diff b/w varchar(N) & text  (sathiya psql <sathiya.psql@gmail.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: sathiya psql
Date:
Subject: Re: Exclude fields from SELECT command
Next
From: Srikanth
Date:
Subject: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps