Re: [HACKERS] Re: bug on aggregate function AVG() - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] Re: bug on aggregate function AVG()
Date
Msg-id 366CC9DB.5143D705@alumni.caltech.edu
Whole thread Raw
In response to Re: [HACKERS] Re: bug on aggregate function AVG()  ("Thomas G. Lockhart" <lockhart@alumni.caltech.edu>)
List pgsql-hackers
> MIN() and MAX() doesn't accept a string as parameter.

I've added capabilities to do min() and max() on strings. To help with
this I've put the new implicit type coersion techniques into the
aggregate function handling. So, for example, the same routine which
handles min(text) will also handle min(char()) and min(varchar()).

These changes are already in the main cvs tree, but are not in the
v6.4.x branch since they require a small number of catalog changes to
implement.

Will post the patches on the patches list in case anyone needs them
before v6.5 comes out...
                      - Tom


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Proposed autoconf change: rip out search for 'install'
Next
From: Constantin Teodorescu
Date:
Subject: Re: libpgtcl.dll for Windows