From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
Cc: | Joel Jacobson <joel(at)trustly(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: PL/pgSQL 2 |
Date: | 2014-09-01 14:23:10 |
Message-ID: | CAFj8pRDCYGQ3acHoc0_cMezh6u7K7tpTp=jzXJ_UELm2-wJSpQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
2014-09-01 16:18 GMT+02:00 Craig Ringer <craig(at)2ndquadrant(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2014-09-01 14:24:37 | Re: PL/pgSQL 2 |
Previous Message | Craig Ringer | 2014-09-01 14:20:37 | Re: PL/pgSQL 2 |