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
< Previous |
Add a Reply
This forum does not allow anonymous participation.
Log in to add a reply. Not registered? Create an account to participate and receive email updates when replies are posted to this topic.