aboutsummaryrefslogtreecommitdiff
path: root/doc/man/insert.l
diff options
context:
space:
mode:
Diffstat (limited to 'doc/man/insert.l')
-rw-r--r--doc/man/insert.l113
1 files changed, 0 insertions, 113 deletions
diff --git a/doc/man/insert.l b/doc/man/insert.l
deleted file mode 100644
index 4db474dd673..00000000000
--- a/doc/man/insert.l
+++ /dev/null
@@ -1,113 +0,0 @@
-.\" This is -*-nroff-*-
-.\" XXX standard disclaimer belongs here....
-.\" $Header: /cvsroot/pgsql/doc/man/Attic/insert.l,v 1.1.1.1 1996/08/18 22:14:24 scrappy Exp $
-.TH INSERT SQL 11/05/95 Postgres95 Postgres95
-.SH NAME
-insert \(em insert tuples to a relation
-.SH SYNOPSIS
-.nf
-\fBinsert\fR into classname
- [(att.expr-1,{att_expr.i})]
- {\fBvalues\fR (expression1 {,expression-i}) |
- \fBselect\fR expression1,{expression-i}
- [\fBfrom\fR from-list] [\fBwhere\fR qual]
-.fi
-.SH DESCRIPTION
-.BR Insert
-adds instances that satisfy the qualification,
-.IR qual ,
-to
-.IR classname .
-.IR Classname
-must be the name of an existing class. The target list specifies the
-values of the fields to be appended to
-.IR classname .
-That is, each
-.IR att_expr
-specifies a field (either an attribute name or an attribute name plus
-an array specification) to which the corresponding
-.IR expression
-should be assigned. The fields in the target list may be listed in
-any order. Fields of the result class which do not appear in the
-target list default to NULL. If the expression for each field is not
-of the correct data type, automatic type coercion will be attempted.
-.PP
-An array initialization may take exactly one of the following forms:
-.nf
---
--- Specify a lower and upper index for each dimension
---
-att_name[lIndex-1:uIndex-1]..[lIndex-i:uIndex-i] = array_str
-
---
---Specify only the upper index for each dimension
---(each lower index defaults to 1)
---
-att_name[uIndex-1]..[uIndex-i] = array_str
-
---
---Use the upper index bounds as specified within array_str
---(each lower index defaults to 1)
---
-att_name = array_str
-.fi
-where each
-.IR lIndex
-or
-.IR uIndex
-is an integer constant and
-.IR array_str
-is an array constant (see
-.IR introduction (l)).
-.PP
-
-If the user does not specify any array bounds (as in the third form)
-then Postgres will attempt to deduce the actual array bounds from the
-contents of
-.IR array_str .
-
-If the user does specify explicit array bounds (as in the first and
-second forms) then the array may be initialized partly or fully
-using a C-like syntax for array initialization.
-However, the uninitialized array elements will
-contain garbage.
-.PP
-You must have write or append access to a class in order to append to
-it, as well as read access on any class whose values are read in the
-target list or qualification (see
-.IR "change acl" (l)).
-.SH EXAMPLES
-.nf
---
---Make a new employee Jones work for Smith
---
-insert into emp
- select newemp.name, newemp.salary,
- "Smith", 1990-newemp.age
- from newemp
- where name = "Jones"
-.fi
-.nf
---
---Insert into newemp class to newemp
---
-insert into newemp
- select * from newemp1
-.fi
-.nf
---
---Create an empty 3x3 gameboard for noughts-and-crosses
---(all of these queries create the same board attribute)
---
-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,'{{,,},{,,},{,,}}')
-.fi
-.SH "SEE ALSO"
-create table(l),
-create type(l),
-update(l),
-select(l)