Array unnest Problem

Help
Matzi1974
2012-05-13
2014-01-19
  • Matzi1974

    Matzi1974 - 2012-05-13

    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 
    -> ARRAY['Foo','BAR']
    SELECT * from UNNEST((SELECT * from test))
    -> no results
    

    Any hints?

     
  • Fred Toussi

    Fred Toussi - 2012-05-13

    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.

     
  • Matzi1974

    Matzi1974 - 2012-05-13

    I tried the script obove using the latest 2.2.8 Release using DatabaseManagerSwing:
    It did not return a result

    Thanks

     
  • Fred Toussi

    Fred Toussi - 2012-05-13

    Please use the snapshot jar dated 24 April 1012 or later. Link is on the "support" page of the website.

     
  • Matzi1974

    Matzi1974 - 2012-05-13

    Thanks! Works with latest SNAPSHOT

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks