ISTM supporting "somefunc.ambiguous" just gives us another way to
 reference the parameter, and there still isn't any way to refer the
 column.


Could we not, at least, support explicit column disambiguation?

e.g.  This PL/SQL procedure:

   CREATE OR REPLACE PROCEDURE insert_emp (empno emp.empno%TYPE,
                                           ename emp.ename%TYPE) IS
   BEGIN
           INSERT INTO emp (empno, ename) VALUES (empno, ename);
   END;

is tantamount to writing this:

   CREATE OR REPLACE PROCEDURE insert_emp (empno emp.empno%TYPE,
                                           ename emp.ename%TYPE) IS
   BEGIN
           INSERT INTO emp (emp.empno, emp.ename)
                  VALUES (insert_emp.empno, insert_emp.ename);
   END;

Both are valid, and notice how the latter evinces disambiguation
supported both ways.

--
Affan Salman
EnterpriseDB Corporation                      http://www.enterprisedb.com


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to