út 9. 3. 2021 v 11:32 odesílatel Joel Jacobson <j...@compiler.org> napsal:
> On Thu, Mar 4, 2021, at 16:40, Tom Lane wrote: > > My experience with working with parallel arrays in SQL has been unpleasant. > > > Could you please give an example on such an unpleasant experience? > it was more complex application with 3D data of some points in 2D array. Everywhere was a[d, 0], a[d, 1], a[d, 2], instead a[d] or instead a[d].x, ... > I can see a problem if the arrays could possibly have difference > dimensionality/cardinality, > but regexp_positions() could guarantee they won't, so I don't see a > problem here, > but there is probably something I'm missing here? > I think so the functions based on arrays can work, why not. But the semantic is lost. > /Joel >
