aboutsummaryrefslogtreecommitdiff
path: root/src/bin/pgaccess/lib/help/insert.hlp
diff options
context:
space:
mode:
Diffstat (limited to 'src/bin/pgaccess/lib/help/insert.hlp')
-rw-r--r--src/bin/pgaccess/lib/help/insert.hlp54
1 files changed, 0 insertions, 54 deletions
diff --git a/src/bin/pgaccess/lib/help/insert.hlp b/src/bin/pgaccess/lib/help/insert.hlp
deleted file mode 100644
index 961fe2560b8..00000000000
--- a/src/bin/pgaccess/lib/help/insert.hlp
+++ /dev/null
@@ -1,54 +0,0 @@
-.pgaw:Help.f.t insert end "INSERT" {bold} " allows one to insert new rows into a table. One can insert a single row at time or several rows as a result of a query. The columns in the target list may be listed in any order. In every \
-column not present in the target list will be inserted the default value, if column has not a declared default value it will be assumed as NULL. If the expression for each column is not of the \
-correct data type, automatic type coercion will be attempted.
-
-" {} "Synopsis" {bold} "
-" {} "
- INSERT INTO table \[ ( column \[, ...\] ) \]
- \{ VALUES ( expression \[, ...\] ) | SELECT query \}
-
-" {code} "Usage" {bold} "
-" {} "
- --Insert a single row into table films;
- --(in the second example the column date_prod is omitted
- --therefore will be stored in it a default value of NULL):
- --
- INSERT INTO films VALUES
- ('UA502','Bananas',105,'1971-07-13','Comedy',INTERVAL '82 minute');
-
- INSERT INTO films (code, title, did, date_prod, kind)
- VALUES ('T_601', 'Yojimbo', 106, DATE '1961-06-16', 'Drama');
-
-
- --Insert a single row into table distributors, note that
- --only column \"name\" is specified, to the non specified
- --column \"did\" will be assigned its default value:
- --
- INSERT INTO distributors (name) VALUES ('British Lion');
-
-
- --Insert several rows into table films from table tmp:
- --
- INSERT INTO films
- SELECT * FROM tmp;
-
-
- --Insert into arrays:
- --Create an empty 3x3 gameboard for noughts-and-crosses
- --(all of these queries create the same board attribute)
- --(Refer to the PostgreSQL User's Guide for further
- --information about arrays).
-
- INSERT INTO tictactoe (game, board\[1:3\]\[1:3\])
- VALUES (1,'\{\{\"\",\"\",\"\"\},\{\},\{\"\",\"\"\}\}');
- INSERT INTO tictactoe (game, board\[3\]\[3\])
- VALUES (2,'\{\}');
- INSERT INTO tictactoe (game, board)
- VALUES (3,'\{\{,,\},\{,,\},\{,,\}\}');
-
-" {code} "Compatibility" {bold} "
-
-SQL92
-
-The INSERT statement is fully compatible with SQL92. Possible limitations in features of the query clause are documented for the SELECT statement.
-"