On Mon, 30 May 2011 11:02:34 +0200
Pavel Stehule <pavel.stehule@gmail.com> wrote:
>> 2) I took from your blog entry
>> (http://okbob.blogspot.com/2008/06/execute-using-feature-in-postgresql-84.html)
>> that it is good practice to use EXECUTE USING.
>> Well, there's no danger of SQL injection as this particular DB runs
>> on an internal network. However, I am wondering whether EXECUTE
>> USING has a performance advantage?
>>
>
>You newer know where or who is attacker :)
>The performance is very similar now - the most slow part is generating
>of execution plan - not IO operations.
I have converted my generic trigger to use EXECUTE ... USING.
I need to convert all NEW values to a text array, retaining their
ordinal position.
avals(hstore(NEW)) doesn't seem to do that:
NEW: (5,name5,1000,,,2)
avals(hstore(NEW)): {5,name5,2,1000,NULL,NULL}
The best I can come up with is a JOIN with information_schema.columns.
--
Best Regards,
Tarlika Elisabeth Schmitz
