Re: V0.2 patch for TODO Item: SQL-language referenceparameters by name. - Mailing list pgsql-patches

From Gregory Stark
Subject Re: V0.2 patch for TODO Item: SQL-language referenceparameters by name.
Date
Msg-id 87ejf7s0r3.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: V0.2 patch for TODO Item: SQL-language reference parameters by name.  (David Fetter <david@fetter.org>)
Responses Re: V0.2 patch for TODO Item: SQL-language referenceparameters by name.
List pgsql-patches
"David Fetter" <david@fetter.org> writes:

> What I mean by "kinda" is that it's a standard way of handling
> parameters in Oracle and in DBI.

That's a good reason *not* to use them for other purposes. Users trying to
create procedures through DBI or other interfaces like it will run into
problems when the driver misinterprets the parameters.

> I think it would be a very bad idea
> to require that people use the function name in parameters,

I think were talking about only allowing it to disambiguate if the name is
shadowed by a variable in an inner scope.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's RemoteDBA services!

pgsql-patches by date:

Previous
From: David Fetter
Date:
Subject: Re: V0.2 patch for TODO Item: SQL-language reference parameters by name.
Next
From: "Gevik Babakhani"
Date:
Subject: Re: V0.2 patch for TODO Item: SQL-language referenceparameters by name.