Jerry Sievers wrote: > After for the umpteenth time bashing my head against a wall developing > some PL funcs that use dynamic SQL, going plain bonkers trying to > build the query string; I came up with a function like the one below > to take a string with placeholders, an array of values to be > interpolated and a placeholder char. (This may appear Pythonish to > some. > > Question: Am I overlooking a simple way of doing this? > > As in; raise notice 'Foo % %', v_var1, v_var2; No, you aren't. AFAICT there isn't any way to do that, and I missed it not too long ago. I'm not sure about the exact syntax, and certainly I expect this to become less of an issue with plan invalidation on 8.3, but IMHO it would be good to have something like Python %(f)s string interpolation (or just plain string interpolation like in other languages). -- Alvaro Herrera http://www.advogato.org/person/alvherre "Cuando no hay humildad las personas se degradan" (A. Christie) ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
