[h2] Single element array-literal?

Hi, is there a literal form to describe an array with only 1 element? For 2+ elements it works like this: select (1,2,3) select (1) does not result in SQL type ARRAY, the result type is INTEGER. CAST(1 AS ARRAY) results in SQL type ARRAY, but the result is an array containing the String 1, not

Re: [h2] Single element array-literal?

SELECT CAST(CAST( 1 AS INTEGER) AS ARRAY) On 2015-05-04 11:44 AM, christoff.schm...@finaris.de wrote: Hi, is there a literal form to describe an array with only 1 element? For 2+ elements it works like this: *select**(**1*,*2*,*3**)* *select**(**1**)*does not result in SQL type ARRAY, the

Re: [h2] Single element array-literal?

://www.finaris.de und http://www.rapidrep.com From: Noel Grandin noelgran...@gmail.com To: h2-database@googlegroups.com Date: 2015-05-04 11:55 Subject:Re: [h2] Single element array-literal? Sent by:h2-database@googlegroups.com SELECT CAST(CAST( 1 AS INTEGER) AS ARRAY

Re: [h2] Single element array-literal?

: http://www.finaris.de und http://www.rapidrep.com From:Noel Grandin noelgran...@gmail.com To:h2-database@googlegroups.com Date:2015-05-04 11:55 Subject:Re: [h2] Single element array-literal? Sent by:h2-database@googlegroups.com