Re: PL/pgSQL 'i = i + 1' Syntax - Mailing list pgsql-hackers

From William ZHANG
Subject Re: PL/pgSQL 'i = i + 1' Syntax
Date
Msg-id e4fcfr$2rd6$1@news.hub.org
Whole thread Raw
In response to Re: PL/pgSQL 'i = i + 1' Syntax  ("Albe Laurenz" <all@adv.magwien.gv.at>)
List pgsql-hackers
""Albe Laurenz"" <all@adv.magwien.gv.at>
> Tom Lane wrote:
...
> > If modifying the loop variable is disallowed in PL/SQL, I'm all for
> > disallowing it in plpgsql, otherwise not.  Anyone have a
> > recent copy of Oracle to try it on?
>
> I tried this on Oracle 10.2.0.2.0 (which is the most recent version):
>
> SET SERVEROUTPUT ON
> BEGIN
>    FOR i IN 1..10 LOOP
>       i := i + 1;
>       DBMS_OUTPUT.PUT_LINE(i);
>    END LOOP;
> END;
> /
>       i := i + 1;
>       *
> ERROR at line 3:
> ORA-06550: line 3, column 7:
> PLS-00363: expression 'I' cannot be used as an assignment target
> ORA-06550: line 3, column 7:
> PL/SQL: Statement ignored
>
> And the documentation also explicitly states that it is not allowed.
>
> By the way, PL/SQL screams if you want to do an assignment with '='.
> But I guess that the current behaviour of PL/pgSQL should not reflect
> that to maintain backward compatibility, right?
>

I think Oracle's syntax and behaviour are better.
As for this feature, breaking the backward compatibility is acceptable.

Regards,
William ZHANG




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dump and backslash escapes
Next
From: Bruce Momjian
Date:
Subject: Re: pg_dump and backslash escapes