cartodb/crankshaft
1
0
Fork 0
mirror of https://github.com/CartoDB/crankshaft.git synced 2024-11-01 10:20:48 +08:00
Code Issues Packages Projects Releases Wiki Activity
develop
crankshaft/doc/04_pyAgg.md
Stuart Lynn 5f98735ce9 adding documentation for pyagg helper
2016-06-28 16:04:23 +00:00

783 B
Raw Permalink Blame History

PyAgg Helper Function

CDB_pyAgg (columns Numeric[])

Currently it's not possible to pass a multidiemensional array between plpsql and plpythonu. This function aims to help fix that by aggergating the columns provided in the argument across rows in to a rows * columns + 1 length 1D array. The first element of the array is the array_length of the columns argument so that python can reconstruct the 2D array.

Arguments

Name Type Description
columns NUMERIC[] The columns to aggregate across rows

Returns

A table with the following columns.

Column Name Type Description
result NUMERIC[] An columns * rows + 1 array where the first entry is the no of columns