7 Replies Latest reply on Dec 9, 2010 9:57 PM by jalen zhong

    How to retrieve many rows using TEXTTABLE

    jalen zhong Newbie

      We want to use a "texttable" to retrieve many rows:

       

      SELECT
        *
      FROM
        TEXTTABLE('row1_col1,row1_col2,row2_col1,row2_col2' COLUMNS rol1 string, rol2 string) AS test

       

      But it can only retrieve one row: ['row1_col1', 'row1_col2'] instead of ['row1_col1', 'row1_col2'], ['row2_col1', 'row2_col2'].

       

      We try to add '\n' in the select clause, but it doesn't work.