I try to unnest a array of varchars (using HSQLDB 2.2.4):
CREATE TABLE TEST (members varchar(30) ARRAY)
insert into test values (ARRAY['Foo', 'BAR'])
SELECT * from test
SELECT * from UNNEST((SELECT * from test))
-> no results
This works in the current code version and should work in the latest release version.
In a real application, the inner select must return only one row.
I tried the script obove using the latest 2.2.8 Release using DatabaseManagerSwing:
It did not return a result
Please use the snapshot jar dated 24 April 1012 or later. Link is on the "support" page of the website.
Thanks! Works with latest SNAPSHOT
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.