SCM

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

View Trackers | Feature Requests | Download .csv | Monitor

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).

Attached Files:

Changes:

No Changes Have Been Made to This Item

Powered By FusionForge