Never mind, I read the documentation correctly this time, arrays are typed
now.
On Tuesday, 21 December 2021 at 10:22:50 UTC+2 pieter...@gmail.com 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 h2-database+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/51bd8aed-23a1-4114-849b-ae376b24713dn%40googlegroups.com.