[#1010369] Adding '?' as acceptable leading char in parameter names

Date:
2008-04-03 08:50 Priority:
3

State:
Open

Submitted by:
Manuel de la Pena (mandel) Assigned to:
Nobody (None)

Category: Group:

Resolution:
None

Summary:
Adding '?' as acceptable leading char in parameter names

Detailed description
People that are used to code using the Oracle client have the habit of using '?' as the leading char for parameter names instead of '@' of ':'. It would be a really nice feature to accept'?' as the leading character since it will ease the migration from Oracle to PostgreSQL.

Followup

Message
Date: 2010-01-19 19:07 Sender: Alaric Dailey If you use the data that .NET dataproviders provider (see my article at codeproject http://www.codeproject.com/KB/database/DataSourceInformation.aspx ) you don't really care WHICH character the provider uses to denote named parameters.
Date: 2010-01-19 17:48 Sender: Alaric Dailey Oracle doesn't use ? as a leading character for parameter names. It uses : ? would be a major problem as that is the character denoting positional parameters like this. select * from "user" where "name"=? and "password"=?
Date: 2008-12-18 20:06 Sender: Josh Cooley It's my understanding that ODP.NET uses ':' as the leading character for parameters. I believe the ? is from OleDB and ODBC.
Date: 2008-12-18 19:24 Sender: Jon Hanna I've long wondered why we don't use $, since that's the form used in postgres' own sql and plpgsql and elsewhere. On the flip side, two many semantically significant characters increases the chance of bugs (people used to SQLServer not expecting ? to be treated that way, people used to Oracle not expecting @ to be treated that way, and so on).

No Changes Have Been Made to This Item