Tom Lane wrote:
Robert Treat [EMAIL PROTECTED] writes:
Funny. That's a good argument for doing it that way, but almost the same
argument I make for putting the INTO at the end: so as to not confuse
people with the SELECT a,b,c INTO newtable FROM oldtable sql syntax.
In either case ISTM
Tom Lane writes:
Robert Treat [EMAIL PROTECTED] 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
Peter Eisentraut [EMAIL PROTECTED] writes:
Well, that position is a strange choice. The standard syntax of SELECT
INTO in embedded SQL is
SELECT a, b, c INTO :x, :y, :z FROM ...
This should probably be consistent.
Well, I'm not wedded to the current recommendation, but we'll never be
able to
Sorry Neil. I thought I recalled you submitting a similar patch, but
must have missed it in the archives and didn't see the change reflected
in cvs so assmeme'd that your change was in a different place.. :-(
Robert Treat
On Tue, 2003-11-25 at 14:04, Neil Conway wrote:
Robert Treat [EMAIL
Ummm - surely the original was correct?
Chris
Robert Treat wrote:
Marcos Truchado [EMAIL PROTECTED] reported this on -docs yesterday.
Robert Treat
Index: plpgsql.sgml
The reported correction was removing the superfluous full_name varchar (which
Neil Conway also reported a few days back). When i was rewriting the
function, I subconsciously switched the SELECT INTO statement to the (IMHO)
more legible syntax, though nothing was wrong with the previous