2014-09-01 16:18 GMT+02:00 Craig Ringer <cr...@2ndquadrant.com>: > On 09/01/2014 10:11 PM, Pavel Stehule wrote: > > > > It can be solution, but I dislike it .. It increase a language > > complexity .. vars with or without prefix .. and more, hidden dynamic > SQL > > > > Nothing what I like - I have a mental barrier to this concept. > > Yeah - the question is whether it's better than using EXECUTE. > > I'm not convinced it is, since it doesn't make things any more > discoverable for new users, and existing users already know how to do it > right. > > It'd only really improve things if PL/PgSQL had started off using > $variable notation, or something that wasn't otherwise legal as an > identifier. >
yes .. dynamic SQL is terrible but it is good to understand to this concept quickly - because it is core of integration SQL to PL/pgSQL. > > I don't love how it works now, but I don't have a better answer really. > I have same opinion. It is not ideal now, but I don't any better ideal > > -- > Craig Ringer http://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Training & Services >