Re: [HACKERS] proposal, plpgsql, 8.4, for record in cursor

2007-11-26 Thread Chris Browne
[EMAIL PROTECTED] (Peter Eisentraut) writes: > Am Montag, 26. November 2007 schrieb Tom Lane: >> "Pavel Stehule" <[EMAIL PROTECTED]> writes: >> > I propose new kind of FOR statement .. iteration over cursor, >> >> This seems useless and probably syntactically ambiguous. > > I think that is isomorph

Re: [HACKERS] proposal, plpgsql, 8.4, for record in cursor

2007-11-26 Thread Pavel Stehule
On 26/11/2007, Tom Lane <[EMAIL PROTECTED]> wrote: > "Pavel Stehule" <[EMAIL PROTECTED]> writes: > > I propose new kind of FOR statement .. iteration over cursor, > > This seems useless and probably syntactically ambiguous. > I don't see any syntactically problem and I have working prototype. This

Re: [HACKERS] proposal, plpgsql, 8.4, for record in cursor

2007-11-26 Thread Peter Eisentraut
Am Montag, 26. November 2007 schrieb Tom Lane: > "Pavel Stehule" <[EMAIL PROTECTED]> writes: > > I propose new kind of FOR statement .. iteration over cursor, > > This seems useless and probably syntactically ambiguous. I think that is isomorphic to what he mentioned as "better conformance with P

Re: [HACKERS] proposal, plpgsql, 8.4, for record in cursor

2007-11-26 Thread Tom Lane
"Pavel Stehule" <[EMAIL PROTECTED]> writes: > I propose new kind of FOR statement .. iteration over cursor, This seems useless and probably syntactically ambiguous. regards, tom lane ---(end of broadcast)--- TIP 1: if postin

[HACKERS] proposal, plpgsql, 8.4, for record in cursor

2007-11-26 Thread Pavel Stehule
Hello I propose new kind of FOR statement .. iteration over cursor, There are two reasons: a) better readability of procedure; - SQL statement is outside of statement, b) better conformance with PL/SQL. Sample: CREATE OR REPLACE FUNCTION foo() RETURNS void AS $$ DECLARE c CURSOR(p integer)