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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Pedro Gimeno" <pgsql-001(at)personal(dot)formauri(dot)es>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4083: Return type of MAX and MIN of a VARCHAR column is TEXT
Date: 2008-04-01 18:09:59
Message-ID: 11830.1207073399@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Pedro Gimeno" <pgsql-001(at)personal(dot)formauri(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-04-01 18:49:57 Re: Postgre cant start
Previous Message Olivier Bessière 2008-04-01 17:55:33 Postgre cant start