You can actually use slice to do it: SELECT key , slice(array_agg(value),1,100) as values FROM table. Please note that the array index ...
確定! 回上一頁