I agree with all your points as I encountered them myself, especially
ambiguity and error handling.
The introduced dependency between those functions also is for me a bad
idea but it seemed like the only way to support that use case, but turns
out my assumption that the array literal shouldn't be quoted was wrong,
I managed to execute this query fine:
INSERT INTO item_2d_table VALUES(1, '(1,"{{""(\\""inv
a\\"",42,1.99)"",""(\\"inv b\\",42,1.99)""},{""(\\""inv
c\\"",42,1.99)"",""(\\""inv d\\"",42,2)""}}")');
Thanks for your insights on this,
Kind regards,
Arjan Marku
On 7/15/24 9:15 PM, Tom Lane wrote:
INSERT INTO item_2d_table VALUES(1, '(1,{{("inv a",42,1.99),("inv
b",42,1.99)},{("inv c",42,1.99),("inv d",42,2)}})');