[PD] [psql] object hand-holding
Jamie Bullock
jamie at postlude.co.uk
Tue Dec 11 09:59:30 CET 2007
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 1
>
I 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.
Jamie
--
www.postlude.co.uk
More information about the Pd-list
mailing list