???Varchar()

How about:

create table A(att0 text);

The length limit is something like 2TB or some such.

On Tue, Sep 10, 2002 at 12:19:34PM +0300, Tourtounis Sotiris wrote:

I have listened that through new Postgresql 7.2.2 version there is also
the capability of declaring a varchar type without declaring the maximum
number of storage e.g. create table A(att0 varchar(16)). Is is true?If
it's how is declared beacuse i can't manage it. Specifically i can't
declare create table A(att0 varchar()). Does anyone have any idea about
the subject.Thanks you !

--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/

Do it like this:

create table a (b varchar);

In this usage, varchar is pretty much an alias for text, but some database
front ends find it easier to accept type varchar than text.

On Tue, 10 Sep 2002, Tourtounis Sotiris wrote: