| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: More aggregate functions? |
| Date: | 2004-04-07 16:08:24 |
| Message-ID: | 20040407160824.GA7060@ns.snowman.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> > - BIT_OR
> > - BIT_AND
> > - GROUP_CONCAT (for strings, added in MySQL 4.x)
>
> Unless these are doing something I don't see, they should be easily
> writable using CREATE AGGREGATE.
It'd be nice to have a place to put functions that people have written
and found useful but that aren't part of the base. Even nicer would be
to have this place be on postgresql.org and linked to from the
documentation. I havn't needed BIT_OR or BIT_AND before but I've used
the GROUP_CONCAT-type aggregate a couple of times. The first time I
wanted that function it took me a while to find (though eventually I did
in the mailing lists somewhere).
Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-04-07 16:34:01 | Re: More aggregate functions? |
| Previous Message | P.J. "Josh" Rovero | 2004-04-07 15:58:31 | Re: More aggregate functions? |