Re: unique names in variables and columns in plsql functions

From: Wiebe Cazemier <halfgaar(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: unique names in variables and columns in plsql functions
Date: 2006-03-27 21:38:27
Message-ID: 44285B53.2070809@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Wiebe Cazemier 2006-03-27 21:39:04 Re: unique names in variables and columns in plsql functions
Previous Message Janning Vygen 2006-03-27 19:20:20 Re: Bitfields always atomic? Other way to store attributes?