Re: PSQL Data Type: text vs. varchar(n)

From: "Mark Aufflick" <mark-postgres(at)aufflick(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PSQL Data Type: text vs. varchar(n)
Date: 2006-04-11 06:56:43
Message-ID: 1242f34a0604102356w6a9b9b17g7a7e426995a10c65@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 4 Apr 2006 04:15:06 GMT, Patrick TJ McPhee <ptjm(at)interlog(dot)com> wrote:
> In article <129CC42D-26B3-4426-8A0A-B1117465F1A8(at)pervasive(dot)com>,
> Jim Nasby <jnasby(at)pervasive(dot)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 ;)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2006-04-11 07:04:24 Re: Debian package for freeradius_postgresql module
Previous Message Mark Aufflick 2006-04-11 06:48:21 Re: stored proc vs sql query string