diff options
Diffstat (limited to 'doc/src/sgml/ref/insert.sgml')
| -rw-r--r-- | doc/src/sgml/ref/insert.sgml | 13 |
1 files changed, 7 insertions, 6 deletions
diff --git a/doc/src/sgml/ref/insert.sgml b/doc/src/sgml/ref/insert.sgml index f73c7fafc5e..a77428d33e0 100644 --- a/doc/src/sgml/ref/insert.sgml +++ b/doc/src/sgml/ref/insert.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/insert.sgml,v 1.26 2003/11/29 19:51:39 pgsql Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/insert.sgml,v 1.27 2004/06/09 19:08:13 tgl Exp $ PostgreSQL documentation --> @@ -73,6 +73,9 @@ INSERT INTO <replaceable class="PARAMETER">table</replaceable> [ ( <replaceable <listitem> <para> The name of a column in <replaceable class="PARAMETER">table</replaceable>. + The column name can be qualified with a subfield name or array + subscript, if needed. (Inserting into only some fields of a + composite column leaves the other fields null.) </para> </listitem> </varlistentry> @@ -184,13 +187,11 @@ INSERT INTO films SELECT * FROM tmp; <programlisting> -- Create an empty 3x3 gameboard for noughts-and-crosses --- (all of these commands create the same board) +-- (these commands create the same board) INSERT INTO tictactoe (game, board[1:3][1:3]) - VALUES (1,'{{"","",""},{},{"",""}}'); -INSERT INTO tictactoe (game, board[3][3]) - VALUES (2,'{}'); + VALUES (1,'{{"","",""},{"","",""},{"","",""}}'); INSERT INTO tictactoe (game, board) - VALUES (3,'{{,,},{,,},{,,}}'); + VALUES (2,'{{,,},{,,},{,,}}'); </programlisting> </para> </refsect1> |