On Dec 12, 2007, at 11:52 AM, Jamie Bullock wrote:
On Tue, 2007-12-11 at 15:48 -0500, Hans-Christoph Steiner wrote:
On Dec 11, 2007, at 3:59 AM, Jamie Bullock wrote:
On Mon, 2007-12-10 at 18:07 -0500, Hans-Christoph Steiner wrote:
It seems many things use the "?" alone as the unnamed placeholder, but I only saw MySQL using ?name for named placeholders. It does seem like a nicer syntax rather than using a different character. Perhaps, we should follow pgsql and use "$" and "$name", since "$" is already a marker for replacement vars in Pd. I suppose that could get confusing in something like:
SELECT id, ABS(($duration - $1)/$2) AS error FROM datatable
ORDER BY error LIMIT 1I vote that we use "?" as a placeholder, and only support unnamed placeholders. We can use this to convert to whatever the db-specific placeholder system is inside the external.
I am ok with using ?name for placeholders, but I think we should also support the plain ? with the list input. I am fine if that happens later tho. I'd like to get something working soon, we've done a lot of talking :).
I agree about getting on with it. However, I probably won't be able to commit any coding time to [psql] until after Christmas. This might be sensible though - I suggest we get the interface to one of the objects 'right' first and then copy this in the others. Mike seems to be
pretty active on the SQLite one, so I suggest we let that take the lead and follow that.
Sounds like a plan :)
.hc
Looking at things from a more basic level, you can come up with a
more direct solution... It may sound small in theory, but it in
practice, it can change entire economies. - Amy Smith