Re: [HACKERS] Aggregate rollup

2003-03-06 Thread Merlin Moncure
-Original Message- From: mlw [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 3:47 PM To: [EMAIL PROTECTED] Subject: [HACKERS] Aggregate rollup I had written a piece of code about two years ago that used the aggregate feature of PostgreSQL to create an array of integers

Re: [HACKERS] Aggregate rollup

2003-03-06 Thread mlw
Merlin Moncure wrote: -Original Message- From: mlw [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 05, 2003 3:47 PM To: [EMAIL PROTECTED] Subject: [HACKERS] Aggregate rollup I had written a piece of code about two years ago that used the aggregate feature of PostgreSQL to create

Re: [HACKERS] Aggregate rollup

2003-03-05 Thread Joe Conway
mlw wrote: I had written a piece of code about two years ago that used the aggregate feature of PostgreSQL to create an array of integers from an aggregate, as: select int_array_aggregate( column ) from table group by column While it seems pointless to create an array on a select, it has a

Re: [HACKERS] Aggregate rollup

2003-03-05 Thread Greg Stark
mlw [EMAIL PROTECTED] writes: I had written a piece of code about two years ago that used the aggregate feature of PostgreSQL to create an array of integers from an aggregate, as: select int_array_aggregate( column ) from table group by column I found this and am using it extensively. It's