Re: minor cleanup in plpgsql.sgml - Mailing list pgsql-patches

From Tom Lane
Subject Re: minor cleanup in plpgsql.sgml
Date
Msg-id 28070.1069777441@sss.pgh.pa.us
Whole thread Raw
In response to minor cleanup in plpgsql.sgml  (Robert Treat <xzilla@users.sourceforge.net>)
Responses Re: minor cleanup in plpgsql.sgml  (Robert Treat <xzilla@users.sourceforge.net>)
Re: minor cleanup in plpgsql.sgml  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-patches
Robert Treat <xzilla@users.sourceforge.net> writes:
> !     SELECT INTO users_rec * FROM users WHERE user_id=3;
> --- 986,993 ----
> !     SELECT * FROM users WHERE user_id=3 INTO users_rec;

Why do you want to change the example to disagree with the advice given
just above?

: At present, the INTO clause can appear almost anywhere in the SELECT
: statement, but it is recommended to place it immediately after the
: SELECT key word as depicted above. Future versions of PL/pgSQL may be
: less forgiving about placement of the INTO clause.

            regards, tom lane

pgsql-patches by date:

Previous
From: Robert Treat
Date:
Subject: minor cleanup in plpgsql.sgml
Next
From: Robert Treat
Date:
Subject: Re: minor cleanup in plpgsql.sgml