Postgres Pro
Downloads
Home   >   mailing lists

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

From Mark Aufflick
Subject Re: PSQL Data Type: text vs. varchar(n)
Date
Msg-id 1242f34a0604102356w6a9b9b17g7a7e426995a10c65@mail.gmail.com
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 
On 4 Apr 2006 04:15:06 GMT, Patrick TJ McPhee <ptjm@interlog.com> 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.

Yeah - and LOBs are a royal pain too. Lucky we mostly deal with numbers here ;)

pgsql-general by date:

Previous
From: "Mark Aufflick"
Date:
Subject: Re: stored proc vs sql query string
Next
From: "Dave Page"
Date:
Subject: Re: Debian package for freeradius_postgresql module