Re: Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT
Date
Msg-id 20080402150513.GA29172@alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT  (Pedro Gimeno <pgsql-002@personal.formauri.es>)
Responses Re: Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Olivier Bessière
Date:
Subject: Re: Postgre cant start
Next
From: Pedro Gimeno
Date:
Subject: Re: Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT