Re: PL/pgSQL 2
| От | Pavel Stehule |
|---|---|
| Тема | Re: PL/pgSQL 2 |
| Дата | |
| Msg-id | CAFj8pRDCYGQ3acHoc0_cMezh6u7K7tpTp=jzXJ_UELm2-wJSpQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: PL/pgSQL 2 (Craig Ringer <craig@2ndquadrant.com>) |
| Список | pgsql-hackers |
2014-09-01 16:18 GMT+02:00 Craig Ringer <craig@2ndquadrant.com>:
On 09/01/2014 10:11 PM, Pavel Stehule wrote:Yeah - the question is whether it's better than using EXECUTE.
>
> 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.
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
В списке pgsql-hackers по дате отправления: