Hannu Krosing <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly