yii2 icon indicating copy to clipboard operation
yii2 copied to clipboard

Need postgresql helper to build arrays

Open DrDeath72 opened this issue 3 years ago • 3 comments

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[]'

DrDeath72 avatar Jun 24 '21 04:06 DrDeath72

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.

bizley avatar Jun 24 '21 07:06 bizley

last issue is batchInsert exception with many ArrayExpression (> 65000), replace with custom toPgArray function :(

DrDeath72 avatar Jun 24 '21 07:06 DrDeath72

@DrDeath72, can you give example?

sihar avatar Oct 12 '21 09:10 sihar