Hello
A current limits of dynamic work with row types in PL/pgSQL can be
decreased with a possible casts between rows and arrays. Now we have a
lot of tools for arrays, and these tools should be used for rows too.
postgres=# \d mypoint
Composite type "public.mypoint"
Column │ Type │ Modifiers
────────┼─────────┼───────────
a │ integer │
b │ integer │
postgres=# select cast(rmypoint '(10,20) as int[]);
array
────────────
{10,20}
(1 row)
postgres=# select cast(ARRAY[10,20] AS mypoint);
mypoint
─────────
(10,20)
(1 row)
What do you think about this idea?
Regards
Pavel Stehule