Request a Demo
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 [email protected]
Whole thread Raw
In response to Re: PSQL Data Type: text vs. varchar(n)  ([email protected] (Patrick TJ McPhee))
List pgsql-general
Tree view 
On 4 Apr 2006 04:15:06 GMT, Patrick TJ McPhee <[email protected]> wrote:
> In article <[email protected]>,
> Jim Nasby <[email protected]> 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