Re: PL/pgSQL 'i = i + 1' Syntax

Hannu Krosing <hannu@skype.net> writes:
> Ühel kenal päeval, R, 2006-05-19 kell 16:12, kirjutas Jim C. Nasby:
>> IIRC, Oracle handles this by allowing you to prefix variables with the
>> name of the function. 

> what happens if your function name is the same as some table name or
> local record variable name ? would it still bite newcomers ? 

Yeah.  Since functions and tables have independent namespaces in PG
(dunno about Oracle), this didn't seem like much of a solution to me.

I think we should just recommend a coding practice such as _ prefix
for local variables, and leave it at that.
        regards, tom lane