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