Home > mailing lists

Column data type in doc example may be changed to VARCHAR from TEXT - Mailing list pgsql-docs

From	Muhammad Ikram
Subject	Column data type in doc example may be changed to VARCHAR from TEXT
Date	July 18 08:10:35
Msg-id	CAGeimVq=a4B5KhnBjmm5CrwkDuMtBC1=dvL93LUeucyPBS2ufw@mail.gmail.com Whole thread Raw
Responses	Re: Column data type in doc example may be changed to VARCHAR from TEXT
List	pgsql-docs

Hi,

IMHO, a minor issue in the doc. As a good practice we use TEXT data type when we expect longer text e.g. comments, doc kind of columns.

For columns where we know what can be a maximum Text size though variable, we use VARCHAR to limit accidental long text or for other worthy reasons.

Following example may be revised.

From

CREATE TABLE products (    product_no integer,    name text,    price numeric
);

To

CREATE TABLE products (    product_no integer,    name varchar(expected length),    price numeric
);
Muhammad Ikram,
Bitnine Global.

From: David Rowley
Date: 18 July, 08:07:39
Subject: Re: A minor bug in doc. Hovering over heading shows # besides it.

From: Kashif Zeeshan
Date: 18 July, 08:17:20
Subject: Re: A minor bug in doc. Hovering over heading shows # besides it.