Re: Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT

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