From f7ad874ca860f95f050641cbe6f325b7a2afe0b9 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Wed, 29 Oct 2008 11:24:53 +0000 Subject: Since SQL:2003, the array size specification in the SQL ARRAY syntax has been optional. --- doc/src/sgml/array.sgml | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/array.sgml b/doc/src/sgml/array.sgml index b0d6e19abf7..4d762c53d35 100644 --- a/doc/src/sgml/array.sgml +++ b/doc/src/sgml/array.sgml @@ -1,4 +1,4 @@ - + Arrays @@ -76,9 +76,12 @@ CREATE TABLE tictactoe ( pay_by_quarter integer ARRAY[4], - This syntax requires an integer constant to denote the array size. + Or, if no array size is to be specified: + + pay_by_quarter integer ARRAY, + As before, however, PostgreSQL does not enforce the - size restriction. + size restriction in any case. -- cgit v1.2.3