Re: Silly Question about varchar(n) - Mailing list pgsql-novice

From Tom Lane
Subject Re: Silly Question about varchar(n)
Date
Msg-id 26523.1043854645@sss.pgh.pa.us
Whole thread Raw
In response to Silly Question about varchar(n)  (Derek Clarkson <dhc@bigpond.net.au>)
List pgsql-novice
Derek Clarkson <dhc@bigpond.net.au> writes:
>     Whats maximum I can put as the length ? - I can't find it in the doco.

I think the parser will complain about N exceeding 10,000,000.

In practice, if you don't have a clear idea of what the upper bound
should be, don't put an upper bound --- use type text.  Putting a
meaninglessly large upper bound simply wastes cycles for useless checks.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Steinn E. Sigurdarson"
Date:
Subject: Re: Good books?
Next
From: "Sugrue, Sean"
Date:
Subject: Re: Good books?