yii2
yii2 copied to clipboard
Need postgresql helper to build arrays
ArrayExpression build array with bind params, on big queries postgresql dies with params limit, need native simple helper to convert array to postgreslq array string like '{1,2,3,4}', '{1,2,3,4}::int[]'
I don't recall anyone asking for that before hence it looks like not a very essential feature. Can't it be solved using plain SQL instead? Anyway we could welcome such helper.
last issue is batchInsert exception with many ArrayExpression (> 65000), replace with custom toPgArray function :(
@DrDeath72, can you give example?