From cecb6075594a407b7adcd9c9a0c243ca4b43c9a3 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 17 Nov 2005 22:14:56 +0000 Subject: Make SQL arrays support null elements. This commit fixes the core array functionality, but I still need to make another pass looking at places that incidentally use arrays (such as ACL manipulation) to make sure they are null-safe. Contrib needs work too. I have not changed the behaviors that are still under discussion about array comparison and what to do with lower bounds. --- doc/src/sgml/ref/insert.sgml | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'doc/src/sgml/ref') diff --git a/doc/src/sgml/ref/insert.sgml b/doc/src/sgml/ref/insert.sgml index a3d03a745a..4e589b599b 100644 --- a/doc/src/sgml/ref/insert.sgml +++ b/doc/src/sgml/ref/insert.sgml @@ -1,5 +1,5 @@ @@ -206,11 +206,11 @@ INSERT INTO films SELECT * FROM tmp_films WHERE date_prod < '2004-05-07'; -- Create an empty 3x3 gameboard for noughts-and-crosses --- (these commands create the same board) INSERT INTO tictactoe (game, board[1:3][1:3]) - VALUES (1,'{{"","",""},{"","",""},{"","",""}}'); + VALUES (1, '{{" "," "," "},{" "," "," "},{" "," "," "}}'); +-- The subscripts in the above example aren't really needed INSERT INTO tictactoe (game, board) - VALUES (2,'{{,,},{,,},{,,}}'); + VALUES (2, '{{X," "," "},{" ",O," "},{" ",X," "}}'); -- cgit v1.2.1