diff options
| author | Bruce Momjian <bruce@momjian.us> | 2000-05-17 00:15:48 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2000-05-17 00:15:48 +0000 |
| commit | 76da5b80b1424cbf467ec8871a264db3885efd53 (patch) | |
| tree | 46e956cd04e8f9d5003aab199829fa3dab63e10a | |
| parent | d446c129aceaab1acc0870f1ab35c0c85038483f (diff) | |
| download | postgresql-76da5b80b1424cbf467ec8871a264db3885efd53.tar.gz postgresql-76da5b80b1424cbf467ec8871a264db3885efd53.zip | |
Change plpgsql example from SELECT * INTO rec to SELECT INTO rec *.
| -rw-r--r-- | doc/src/sgml/plsql.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/plsql.sgml b/doc/src/sgml/plsql.sgml index 6ac162edf97..fe606722571 100644 --- a/doc/src/sgml/plsql.sgml +++ b/doc/src/sgml/plsql.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/Attic/plsql.sgml,v 2.7 2000/05/16 21:16:12 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/Attic/plsql.sgml,v 2.8 2000/05/17 00:15:48 momjian Exp $ --> <chapter> @@ -435,7 +435,7 @@ CREATE FUNCTION logfunc2 (text) RETURNS datetime AS ' An assignment of a complete selection into a record or row can be done by <programlisting> -SELECT <replaceable>expressions</replaceable> INTO <replaceable>target</replaceable> FROM ...; +SELECT INTO <replaceable>target</replaceable> <replaceable>expressions</replaceable> FROM ...; </programlisting> <replaceable>target</replaceable> can be a record, a row variable or a comma separated list of variables and record-/row-fields. @@ -451,7 +451,7 @@ SELECT <replaceable>expressions</replaceable> INTO <replaceable>target</replacea immediately after a SELECT INTO to check if an assignment had success. <programlisting> -SELECT * INTO myrec FROM EMP WHERE empname = myname; +SELECT INTO myrec * FROM EMP WHERE empname = myname; IF NOT FOUND THEN RAISE EXCEPTION ''employee % not found'', myname; END IF; |