On 11/05/12 12:46 PM, Moshe Jacobson wrote:
Is there any practical difference between defining a column as a varchar(n) vs. a varchar vs. a text field?
varchar(n) has a length constraint on it. the other two don't. otherwise all three are identical in implementation.
I've always been under the impression that if I am wanting to index a varchar column, it is better to set a maximum length. Is this correct?
no, unless you want to ensure the field will never exceed a specified length.
But more importantly, what's the practical difference between varchar with no limit and text?
none. -- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
