Re: unique names in variables and columns in plsql functions - Mailing list pgsql-sql

From Wiebe Cazemier
Subject Re: unique names in variables and columns in plsql functions
Date
Msg-id 44285B53.2070809@gmail.com
Whole thread Raw
In response to Re: unique names in variables and columns in plsql functions  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-sql
(Whoops, pressed wrong reply button. Here it is correctly this time.)

On 03/27/06 16:48, Jim C. Nasby wrote:

>
>Sadly, overloading variable names between plpgsql and SQL is *highly*
>problematic. Because of this I *always* prefix plpgsql variables with
>something, such as p_ for parameters and v_ for general variables.
>  
>
Hmm. Well, at least now I'm aware of it. Perhaps I will do something
similair to prefixes from now on, it would seem to be good practice.


pgsql-sql by date:

Previous
From: Janning Vygen
Date:
Subject: Re: Bitfields always atomic? Other way to store attributes?
Next
From: Wiebe Cazemier
Date:
Subject: Re: unique names in variables and columns in plsql functions