| 11:28:36 | bitner: | jlivni: you can create a custom aggregate |
| 11:28:45 | bitner: | look up array_accum on google |
| 11:28:59 | bitner: | I might actually have a custom agg for just that, let me take a look |
| 11:29:10 | jlivni: | sweet! thx |
| 11:29:15 | jlivni: | this will get me going nicely tho |
| 11:29:33 | bitner: | just a sec, I might have the whole shebang for you |
| 11:29:38 | : | * jlivni waits |
| 11:31:44 | bitner: | hmmm, don't see it right away -- I know I wrote an aggregate at some point in time that even ditched dupes |
| 11:34:21 | bitner: | ahhh, use array_to_string( array_accum( color ) ) |
| 11:34:48 | bitner: | will include dupes I think and you'll likely need to look up and create array_accum |
| 11:35:30 | jlivni: | yup - looks like this will work. t hanks agin! |
| 11:35:35 | jlivni: | er, thanks again! bad keyboard here |
| 11:35:38 | bitner: | np |
| 11:35:56 | bitner: | can probably ditch the dupes by throwing a distinct somewhere in the query |
| 11:36:06 | bitner: | or some such |
| 11:36:14 | jlivni: | on it |