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

From Tom Lane
Subject Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT
Date
Msg-id 11830.1207073399@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT  ("Pedro Gimeno" <pgsql-001@personal.formauri.es>)
Responses Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
"Pedro Gimeno" <pgsql-001@personal.formauri.es> writes:
> Description:        Return type of MAX and MIN of a VARCHAR column is TEXT

This is not a bug.  Most if not all operations with varchar will return
text --- it doesn't have its own operators.

> The last query's return types are both TEXT, which in Zeos are not treated
> in the same way as varchar.

I think you need to file a bug with Zeos to fix whatever their problem
is with text.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #4082: Fatal error, close server
Next
From: Olivier Bessière
Date:
Subject: Postgre cant start