Re: PL/pgSQL 2

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Joel Jacobson <joel(at)trustly(dot)com>
Cc: Craig Ringer <craig(at)2ndquadrant(dot)com>, Andres Freund <andres(at)2ndquadrant(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PL/pgSQL 2
Date: 2014-09-01 14:54:29
Message-ID: CAFj8pRA_OE-OJ_t74_t=1e+0-b8ShU8WBwM6unhPdRF7QswTNw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

2014-09-01 16:41 GMT+02:00 Joel Jacobson <joel(at)trustly(dot)com>:

> 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.
> All the clumsy stuff we cannot fix in plpgsql, can easily be fixed in
> plpgsql2, with the most beautiful syntax we can come up with.
>
> I guess it's a question if we want to support things like this. If we
> want to, then we also want a new language.
>

when you fix it, then you designed totally new language with thin relation
to plpgsql

Pavel

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2014-09-01 14:56:06 Re: psql \watch versus \timing
Previous Message Pavel Stehule 2014-09-01 14:45:47 Re: PL/pgSQL 2