Subscribe

Array unnest Problem

Add A Reply

You are viewing a single message from this topic. View all messages.

  1. matzi1974

    2012-05-13 02:21:40 PDT
    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?
Jump To:
< Previous | 1 | Next >

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.