Re: PL/pgSQL 2 - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: PL/pgSQL 2
Date
Msg-id CAFj8pRDCYGQ3acHoc0_cMezh6u7K7tpTp=jzXJ_UELm2-wJSpQ@mail.gmail.com
Whole thread Raw
In response to Re: PL/pgSQL 2  (Craig Ringer <craig@2ndquadrant.com>)
List 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:
>
> 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

pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: PL/pgSQL 2
Next
From: Andres Freund
Date:
Subject: Re: PL/pgSQL 2