[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