Re: [PATCHES] PLpgSQL: list of scalars as row for assign stmt, fore and fors stm

2005-12-20 Thread Pavel Stehule
"Pavel Stehule" <[EMAIL PROTECTED]> writes: x, y := r; > >>> That strikes me as a really bad idea. It weakens both syntax and >>> semantic error checking, to accomplish how much? >> >> Could use PHP-style thingy: >> LIST(x, y) := r; Actually, ROW(x, y) would be the right spelling per SQL c

Re: [PATCHES] PLpgSQL: list of scalars as row for assign stmt, fore and fors stm

2005-12-20 Thread Tom Lane
"Pavel Stehule" <[EMAIL PROTECTED]> writes: x, y := r; > >>> That strikes me as a really bad idea. It weakens both syntax and >>> semantic error checking, to accomplish how much? >> >> Could use PHP-style thingy: >> LIST(x, y) := r; Actually, ROW(x, y) would be the right spelling per SQL c

Re: [PATCHES] PLpgSQL: list of scalars as row for assign stmt, fore and fors stm

2005-12-20 Thread Pavel Stehule
x, y := r; That strikes me as a really bad idea. It weakens both syntax and semantic error checking, to accomplish how much? Could use PHP-style thingy: LIST(x, y) := r; Chris It's inconsystency :-(. EXECUTE INTO and SELECT INTO use scalar of vectors without anything. Pavel ___

Re: [PATCHES] PLpgSQL: list of scalars as row for assign stmt, fore and fors stm

2005-12-20 Thread Pavel Stehule
Tom Lane said: > "Pavel Stehule" <[EMAIL PROTECTED]> writes: >> x, y := r; > > That strikes me as a really bad idea. It weakens both syntax and > semantic error checking, to accomplish how much? > Where does the idea come from anyway? Has it been discussed on -hackers? I don't recall seein

Re: [PATCHES] PLpgSQL: list of scalars as row for assign stmt, fore and fors stm

2005-12-20 Thread Pavel Stehule
"Pavel Stehule" <[EMAIL PROTECTED]> writes: > x, y := r; That strikes me as a really bad idea. It weakens both syntax and semantic error checking, to accomplish how much? It's same as select into or execute into (using same code). And behave is like row variable := row variable. I am