View Single Post

   
  #2 (permalink)  
Old 04-10-2008, 11:15 AM
Alvaro Herrera
 
Posts: n/a
Default Re: Re: BUG #4083: Return type of MAX and MIN of a VARCHARcolumn 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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply With Quote