V S P wrote:
if I have field declared myvalue text[][] insert into vladik (myval) values ( '{{"\",A", "\"B"}, {"Y", "Q"}}' ) What do you guys use in your treasurechest of 'addons' to successfully parse out the above trickery and get and get the 4 strings ",A "B Y Q from within Postgres stored procedure as well as C++ or other client code. It seems to me that it is not possible with any built-in command available to easily extract the strings out to a multidimensional array
Actually its pretty easy. SELECT myval[i][j] FROM vladik CROSS JOIN generate_series(1, array_upper(myval, 1)) i CROSS JOIN generate_series(1, array_upper(myval, 2)) j -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general