Hi all:
I have a table that has multiple records for a single owner_id. I'm able to
use array_arg to combine the records into a single row, which works fine. I'm
using this sql:
select owner_id, array_agg(trim(maplot)), array_agg(revallandvalue +
revalbuildingvalues) from parcel group by
On Tue, Mar 4, 2014 at 1:49 PM, Owen Hartnett o...@clipboardinc.com wrote:
Hi all:
I have a table that has multiple records for a single owner_id. I'm able to
use array_arg to combine the records into a single row, which works fine.
I'm using this sql:
select owner_id,
Merlin Moncure-2 wrote
On Tue, Mar 4, 2014 at 1:49 PM, Owen Hartnett lt;
owen@
gt; wrote:
It looks like I should be able to use the window function to do this,
but
I've been unsuccessful. The following runs, but doesn't seem to have any
effect:
select owner_id,
