inspector morse <inspectormorse86@gmail.com> writes:
> In all other DBMS, the variable names have a distinctive character to differentiate between variables and column
names:
>
> Example:
> SQL Server uses @
> MySql uses ?
> Oracle uses :
> Firebirdsql uses :
>
> It makes it easier to write and manage queries especially in stored procedures.
>
> Just compare the below:
> create stored procedure get_user_for_editing(user_id int, out username varchar)
> begin
> Â Â select username into @username from users where user_id = @user_id;
> end;
>
> to this mess:
>
> create stored procedure get_user_for_editing(user_id int, out username varchar)
> begin
> Â Â select u.username into get_user_for_editing.username from users u where get_user_for_editing.user_id =
get_user_for_editing.user_id;
> end;
>
> Prefixing the variables (ex: p_user_id) makes the application code harder to write as we have a lot of dynamic code
thatis expecting "user_id" instead of "p_user_id".
>
> Is there any plan to add a character to differentiate between variables?
Not that I'm aware of but please submit a patch or do not hesitate to
run any of those other platforms where things are not such a mess :-)
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800