Never mind, I read the documentation correctly this time, arrays are typed now.
On Tuesday, 21 December 2021 at 10:22:50 UTC+2 [email protected] wrote: > Hi, > > Running > > CREATE TABLE "PUBLIC"."V_Person" ("ID" IDENTITY NOT NULL PRIMARY KEY, > "age" ARRAY); > > fails with > > Syntax error in SQL statement "CREATE TABLE ""PUBLIC"".""V_Person"" > (""ID"" IDENTITY NOT NULL PRIMARY KEY, \000a\0009""age"" ARRAY[*]);"; > expected "IDENTITY, data type"; SQL statement: > CREATE TABLE "PUBLIC"."V_Person" ("ID" IDENTITY NOT NULL PRIMARY KEY, > "age" ARRAY); [42001-202] > > This work on 1.4.200, > Can someone show me the correct syntax please? > > The same sql works for other data types. > > Thanks > Pieter > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/51bd8aed-23a1-4114-849b-ae376b24713dn%40googlegroups.com.
