Re: RfD: more powerful "any" types

On Sep 12, 2009, at 5:54 PM, Andrew Dunstan wrote:
> decibel wrote:
>> Speaking of concatenation...
>>
>> Something I find sorely missing in plpgsql is the ability to put  
>> variables inside of a string, ie:
>>
>> DECLARE
>> v_table text := ...
>> v_sql text;
>> BEGIN
>> v_sql := "SELECT * FROM $v_table";
>>
>> Of course, I'm assuming that if it was easy to do that it would be  
>> done already... but I thought I'd just throw it out there.
>>
>
> Then use a language that supports variable interpolation in  
> strings, like plperl, plpythonu, plruby .... instead of plpgsql.


Which makes executing SQL much, much harder.

At least if we get sprintf dealing with strings might become a bit  
easier...
-- 
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828