11<!--
2- $Header: /cvsroot/pgsql/doc/src/sgml/Attic/plsql.sgml,v 2.7 2000/05/16 21:16:12 momjian Exp $
2+ $Header: /cvsroot/pgsql/doc/src/sgml/Attic/plsql.sgml,v 2.8 2000/05/17 00:15:48 momjian Exp $
33-->
44
55 <chapter>
@@ -435,7 +435,7 @@ CREATE FUNCTION logfunc2 (text) RETURNS datetime AS '
435435An assignment of a complete selection into a record or row can
436436be done by
437437<programlisting>
438- SELECT <replaceable>expressions </replaceable>INTO <replaceable>target </replaceable> FROM ...;
438+ SELECT INTO <replaceable>target </replaceable> <replaceable>expressions </replaceable> FROM ...;
439439</programlisting>
440440<replaceable>target</replaceable> can be a record, a row variable or a
441441comma separated list of variables and record-/row-fields.
@@ -451,7 +451,7 @@ SELECT <replaceable>expressions</replaceable> INTO <replaceable>target</replacea
451451immediately after a SELECT INTO to check if an assignment had success.
452452
453453<programlisting>
454- SELECT* INTO myrec FROM EMP WHERE empname = myname;
454+ SELECT INTO myrec * FROM EMP WHERE empname = myname;
455455IF NOT FOUND THEN
456456 RAISE EXCEPTION ''employee % not found'', myname;
457457END IF;