Re: [GENERAL] difference b/w text and varchar datatypes

2006-10-16 Thread Richard Broersma Jr
> can you please provide me the link for the same. > thanks The faq is under the documentation link of the PostgreSQL homepage. http://www.postgresql.org/docs/faq/ ---(end of broadcast)--- TIP 4: Have you searched our list archives?

Re: [GENERAL] difference b/w text and varchar datatypes

2006-10-16 Thread Richard Broersma Jr
> Just wanted to know how would it make a difference if i use text datatype > instead of varchar. Taken from: http://www.postgresql.org/docs/8.1/interactive/datatype-character.html " If character varying is used without length specifier, the type accepts strings of any size. The latter is a Pos

Re: [GENERAL] difference b/w text and varchar datatypes

2006-10-16 Thread Harpreet Dhaliwal
can you please provide me the link for the same.thanksOn 10/16/06, Bruce Momjian <[EMAIL PROTECTED]> wrote: Harpreet Dhaliwal wrote:> Hi,> Just wanted to know how would it make a difference if i use text datatype > instead of varchar.See FAQ item.--  Bruce Momjian   [EMAIL PROTECTED]  EnterpriseDB 

Re: [GENERAL] difference b/w text and varchar datatypes

2006-10-16 Thread Bruce Momjian
Harpreet Dhaliwal wrote: > Hi, > Just wanted to know how would it make a difference if i use text datatype > instead of varchar. See FAQ item. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---

[GENERAL] difference b/w text and varchar datatypes

2006-10-16 Thread Harpreet Dhaliwal
Hi,Just wanted to know how would it make a difference if i use text datatype instead of varchar.Thanks,~Harpreet