Postgres Pro
Downloads
Home   >   mailing lists

Re: PSQL Data Type: text vs. varchar(n) - Mailing list pgsql-general

From Jeffrey Melloy
Subject Re: PSQL Data Type: text vs. varchar(n)
Date
Msg-id 44341290.5050502@visualdistortion.org
Whole thread Raw
In response to Re: PSQL Data Type: text vs. varchar(n)  (ptjm@interlog.com (Patrick TJ McPhee))
List pgsql-general
Tree view 
Patrick TJ McPhee wrote:

>In article <129CC42D-26B3-4426-8A0A-B1117465F1A8@pervasive.com>,
>Jim Nasby <jnasby@pervasive.com> wrote:
>
>% Not sure if it's still true, but DB2 used to limit varchar to 255. I
>% don't think anyone limits it lower than that.
>
>Sybase: 254. Silently truncates.
>
>
>
IIRC, Oracle is 4096.

Jeff

pgsql-general by date:

Previous
From: "Jonas F. Henriksen"
Date:
Subject: Re: full join question...
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Creating an index on PostgreSQL 7.4.3