From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of inspector morse
Sent: Thursday, February 19, 2015 7:58 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] stored procedure variable names
In all other DBMS, the variable names have a distinctiv
2015-02-20 1:57 GMT+01:00 inspector morse :
> 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 qu
Yeah, I'm using plpgsql.
Actually nevermind on this. I was able to patch my data access utility so
it adds a prefix when calling the stored function and then remove it again
before returning for front end processing.
On Thu, Feb 19, 2015 at 8:44 PM, Adrian Klaver
wrote:
> On 02/19/2015 04:57 PM
On 02/19/2015 04:57 PM, inspector morse wrote:
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 especial
inspector morse writes:
> Is there any plan to add a character to differentiate between variables?
No. You're free to use a naming convention yourself, of course, but
we're not going to break every stored procedure in sight in order
to impose one.
regards, tom lane
--
inspector morse 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 i