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

From Tom Lane
Subject Re: PL/pgSQL 'i = i + 1' Syntax
Date
Msg-id 4328.1148075175@sss.pgh.pa.us
Whole thread Raw
In response to Re: PL/pgSQL 'i = i + 1' Syntax  (Hannu Krosing <hannu@skype.net>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: PL/pgSQL 'i = i + 1' Syntax
Next
From: "Jonah H. Harris"
Date:
Subject: Re: [OT] MySQL is bad, but THIS bad?