On Oct 20, 2009, at 2:02 AM, Eric Day wrote:
Agree as well with :1. The ?1 is used in SQLite and possibly a couple
others. There is also $1 (how PostgreSQL does it), which I forgot
to mention.
Let's stick with :1 unless someone else objects. :)
+1
-Eric
On Mon, Oct 19, 2009 at 11:48:04PM -0700, Monty Taylor wrote:
Kristian Nielsen wrote:
Eric Day <[email protected]> writes:
Thanks to all who responded with the valuable feedback. It sounds
like we need to support '?' for other APIs, and I think supporting
both numeric and string IDs will be trivial on top of this. String
1: INSERT INTO foo VALUES(?, ?1)
This looks terrible with respect to confusion about whether ?1 is
an anonymous
placeholder followed by a digit, or a number placeholder. Not that
the issue
could not be resolved, but why introduce the complication in the
first place?
Agree. Looks more like a syntax error to me.
2: INSERT INTO foo VALUES(?, :1)
This seems the obvious choice to me ...
Agree.
++ for :1 and not ?1
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
