| From: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> |
|---|---|
| To: | Joel Jacobson <joel(at)trustly(dot)com>, Craig Ringer <craig(at)2ndquadrant(dot)com> |
| Cc: | Andres Freund <andres(at)2ndquadrant(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: PL/pgSQL 2 |
| Date: | 2014-09-01 14:44:09 |
| Message-ID: | 54048639.4020803@vmware.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 09/01/2014 05:41 PM, Joel Jacobson wrote:
> On Mon, Sep 1, 2014 at 4:26 PM, Craig Ringer <craig(at)2ndquadrant(dot)com> wrote:
>> Well, the idiom:
>>
>> EXECUTE format("SELECT %I FROM %I WHERE $1", col, tbl) USING val;
>>
>> is not lovely. It works, but it's clumsy.
>
> This is exactly why we need a new language.
We could certainly improve that syntax in PL/pgSQL. No need to start
from scratch for that..
Got a suggestion what the syntax should look like?
- Heikki
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2014-09-01 14:45:47 | Re: PL/pgSQL 2 |
| Previous Message | Joel Jacobson | 2014-09-01 14:41:22 | Re: PL/pgSQL 2 |