Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: Pedro Gimeno <pgsql-002(at)personal(dot)formauri(dot)es>
- Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
- Subject: Re: Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT
- Date: Wed, 2 Apr 2008 11:05:13 -0400
- Message-id: <20080402150513(dot)GA29172(at)alvh(dot)no-ip(dot)org>
Pedro Gimeno escribió: > Zeos (as well as the Borland Database Engine, which it just mimics in > this sense) assumes that VARCHAR fields in general (not just > PostgreSQL's) are textual fields with a limit of 255 characters for all > supported servers, which are graphically associated with single-line > edit controls. Oh, so if you have a column of type VARCHAR(1000) or anything longer than 255 chars it fails too? And I'd guess that if you have a varchar(255) column and store a value longer than 255 bytes (because there are many wide chars) it will fail as well. Both cases should really be tested and taken to Zeos if they fail. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
- Follow-Ups:
- Re: Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT
- From: Pedro Gimeno
- Re: Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT
- References:
- Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT
- From: Pedro Gimeno
- Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT
- Prev by Date: Re: Postgre cant start
- Next by Date: Re: Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT
- Previous by thread: Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT
- Next by thread: Re: Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT
- Indexes: