On Wed, Dec 21, 2005 at 09:26:35AM +0800, Christopher Kings-Lynne wrote:
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;
Better still, the pg way:
[ROW](x, y)
Hello
This patch enhance possibilities fore, fors, assign statements and remove
not needed using row or record variable.
create function a(out x integer, out y integer) returns setof record as $$
declare r record;
begin
for x, y in select form data loop
return next;
end loop;
-- or --
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?
regards, tom lane
---(end of broadcast)---
TIP 5:
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 seeing it. Just
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 not
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 seeing it. Just
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
---(end of broadcast)---
TIP 9: In versions below 8.0, the
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
Pavel Stehule wrote:
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
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 convention.
I am
10 matches
Mail list logo
