diff options
Diffstat (limited to 'src/bin/pgaccess/lib/help/insert.hlp')
-rw-r--r-- | src/bin/pgaccess/lib/help/insert.hlp | 54 |
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. -" |